ConditionalFormatCellValue
 

I have a column with a middle initial or a middle namr or it is blank.
What I need to do is add a period to the middle initial only. If it a
missle name or blank, then I want to do nothing. Is there a function
for something like this?

Thanks

ConditionalFormatCellValue
 

Something like this:
=if(len(a1)=1,a1&".",a1)

Regards,
Fred

"gh" wrote in message
...
I have a column with a middle initial or a middle namr or it is blank. What
I need to do is add a period to the middle initial only. If it a missle
name or blank, then I want to do nothing. Is there a function for
something like this?

Thanks