Placing a "." after single characters only

[ddennis]

Hello All:

I have a spreadsheet with peoples' names. They are separated by Last name, first name and middle name.

Some of the middle names have more than one character.

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.

Is there a formula I can use to accomplish this?

Thank you all very much

Dee

 

[Scott Huish]

=IF(A1="","",A1&IF(LEN(TRIM(RIGHT(A1,2)))=1,".",""))

Excel Workbook
	A	B
1	John, Smith F	John, Smith F.
2	John, Smith Franklin	John, Smith Franklin
3
Sheet1

 

[Straha]

Are the names in separate cells? (i.e. A1 = Last Name, B1 = First Name, C1 = Middle) If so I think you could use

=IF(LEN(C1)>1,C1,C13&".")

 

[ddennis]

Thank you guys!!! Both of you rock!!

Dee