Hi,

It appears that Fred and I both answered simultaneously on your last post
and we both interpreted you request similarly. However, if the cell only
contains one character or empty then assuming that B1 is the cell to test,
you could insert the following into an adjacent cell:-

=IF(B1<"",B1&".","")

You can then Copy the columnwith the formulas and Paste Special - Values
over the original column and then remove the column with the formula.

--
Regards,

OssieMac


"gh" wrote:

Fred Smith wrote:
Substitute might work for you. If the formatting is consistent, it shouldn't be
too hard.

Is the format always FirstName<spaceInitial<spaceLastName?
And without an initial, it's always FirstName<spaceLastName?

If so, you can use Substitute to change the second space to <period<space

If you still need help, post back. Make sure you specify what format the names
are in.

Fred:

The cell only has a middle initial in it or it is empty. There is not a
first or last name. So I want to check the cell for a character and if
it has one, then add a period to it. If not then do nothing.

TIA