Need help adding a period after middle initial.

  • Thread starter Thread starter SteveL
  • Start date Start date
S

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
 
One way:

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

HTH
Jason
Atlanta, GA
 
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
 
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
 
Back
Top