Excel 2007 : Change Address Database from upper case to proper case

**FC Morris** · 10-29-2009, 07:42 PM

I have a excel address database that I am trying to change the all upper case lettering to upper and lower. I have written the formula so many different ways and am still unable to make it work. My database columns are a2 -e2 to a373 to e373. I could really use some help. Thanks

**teylyn** · 10-29-2009, 08:07 PM

Hi,

if you don't want to write a macro for this, you could do the following:

on a new sheet, select A2 and enter

=PROPER(Sheet1!A2)

Copy right to column E

Then copy the formulas down to row 373.

Now select A2:E373, copy, go to Sheet1, select A2 and click Edit - Paste Special - Values. Now all your content should be in proper case. You can now delete the sheet with the formulas.

hth

**DonkeyOte** · 10-30-2009, 03:27 AM

FWIW one possible VBA approach would be:

Please Login or Register  to view this content.

**teylyn** · 10-30-2009, 04:00 PM

FC, if you're still having problems, please post a small data sample and the we can help where to put which formula. Create a workbook that is not too big but has sufficient data to illustrate your problem.

Click the Go Advanced button below and then the paper clip icon in the next screen to attach a file.

cheers