Hello All:
I have a spreadsheet with peoples' names. They are separated by Last name, first name and middle name in different cells.
Some of the middle names have more than one character and some of the people's middle name fields are blank.
I wish to place a "." next the a middle initial ONLY if the middle name contains only one character. If the middle name contains more than one character, it must be ignored as well as a blank middle name field.
Is there a formula I can use to accomplish this?
Thank you all very much
Dee