View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default 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