Changing case on text in an existing spreadsheet

C

christy d

I have an existing spreadsheet containing names and addresses which was
entered in all upper case letters. I would like to convert it to upper/lower
case letters so that when I merge it with a letter it appears correctly.

Thank you
 
B

Bryan Hessey

To convert column A from UPPER to Proper case, insert a helper column B
and, in cell B1, put

=proper(A1)

and formula drag that down

Copy column B and Paste Special = Values back over itsself.
Delete column A

HTH
 
Top