Converting to PROPER text?

[Jenna]

Hi,

I'm having trouble with a huge spreadsheet that I'm working with. It's
a database of names and addresses, and all of it is in capital letters.
Is there a way to apply the 'PROPER' command to the whole spreadsheet?
Or any other ideas???

Thanks so much!

 

[Jenna]

I forgot to say WHAT I want to do, sorry. I want to have it in "PROPER"
form, where the first letter is capatilized and the rest are lower
case.

Thanks!

 

[Peo Sjoblom]

You can do that by using a macro

press Opt + F11, select insert>module and paste in the below

Sub PropCase()
Application.DisplayAlerts = False
Dim R As Range
For Each R In Selection.Cells
If R.HasFormula Then
R.Formula = "=PROPER(" & Mid(R.Formula, 2) & ")"
Else
R.Value = Application.Proper(R.Value)
End If
Next
Application.DisplayAlerts = True
End Sub


Select the values and run the macro

 

[JE McGimpsey]

Hi,

I'm having trouble with a huge spreadsheet that I'm working with. It's
a database of names and addresses, and all of it is in capital letters.
Is there a way to apply the 'PROPER' command to the whole spreadsheet?
Or any other ideas???

Check out David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/proper.htm