Add a character to each row in a column

A

Aboyer

How can I add a period to each row in a column for middle initials (middle
initial only column) that were entered without a period?
 
G

Gary''s Student

Lets assume that the names occupy three columns:

Victor K Lazlo
Anatoly X Klezmer

etc. Create a helper column with the formula =IF(LEN(B1)=1,B1&".",B1) and
copy down. This formula will only append the dot if the middle field was a
single character. Once complete, copy the helper column and paste it special
as value.
 
Top