problem with =PROPER

[Kimberly Wood]

I need to be able to convert text in an Excel worksheet
from all CAPS to Proper Text.

I know there is a way to do this cell by cell. But I have
about 3500 cells to convert and I want to know how to do
column by column.

I know there is a way but I forget

PLEASE HELP!!!!

 

[Paul B]

Kimberly, you could use a macro like this

Sub Proper_Case()
'select the range you want to change
'and run this macro
Application.ScreenUpdating = False
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
Rng.Value = Application.WorksheetFunction.Proper(Rng.Value)
End If
Next Rng
Application.ScreenUpdating = True
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **