ConditionalFormatCellValue

[gh]

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

 

[Fred Smith]

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

Regards,
Fred