Changing case on text in an existing spreadsheet

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert addresses to all caps in Office 2007? 3
Title Case in Excel 3
lower case letter "i" always converts to upper case 1
How do I convert text to uppercase? 2
Changing text case in entire database column from JOHN to John 2
How to change lower to upper case letters? 1
Excel: how to convert text to upper case upon entry? 13
Make cells in Excell case sensitive 3

Top