Changing case on text in an existing spreadsheet
 

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

Changing case on text in an existing spreadsheet
 

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

christy d Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533927