Need help adding a period after middle initial.

[SteveL]

Here's the issue..

In a column of names that may look like:

John H (I need to place a period after the H)
but if it look like
John (leave it alone)
and if it looks like
John H. (leave it alone)

In other words, the only time something should be done
with the field is if the middle initial is there and has
no period following it.

How?

--Steve

 

[Jason Morin]

One way:

=IF(OR(ISNUMBER(FIND(".",A1)),ISERR(FIND
(" ",A1))),A1,A1&".")

HTH
Jason
Atlanta, GA

 

[SteveL]

Jason,

Perfect, except I didn't anticipate one thing...

Example:

John Henry (needs to be left alone). Your code is
putting a period after the "Henry".

Thoughts?

--Steve

 

[Dave R.]

Try this

=IF(ISNUMBER(LEN(A1)-FIND(" ",A1)),IF(LEN(A1)-FIND(" ",A1)=1,A1&".",A1),A1)

 

[RagDyer]

It's best to keep to a single thread.
Yesterday, you used John C Doe as your example.

Are you *changing* or *adding* to your question?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


Jason,

Perfect, except I didn't anticipate one thing...

Example:

John Henry (needs to be left alone). Your code is
putting a period after the "Henry".

Thoughts?

--Steve