AddPeriodToCharaceter
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.
--
Regards,
Fred
"gh" wrote in message
...
I have a column with a middle initial in some of the cells. I would like to
add a period after the initial and the cells without an initial, leave empty.
Is there a function for this?
TIA
|