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

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

FWIW one possible VBA approach would be:

Public Sub DoItProper()
With Range("A2:E373")
    .Value = Evaluate("IF(ISTEXT(" & .Address & "),PROPER(" & .Address & "),REPT(" & .Address & ",1))")
End With
End Sub