Proper function: how to use

[Fernesto48]

I have a column of text; some cells have all upper case letters. I want all cells to have First letter only upper case, the rest in lower case.
I tried the PROPER function but am doing it wrong. I highlight the entire column, select PROPER, put the cells locations in the blank field (e.g., D2:D175), hit OK, nothing, except first cell now says PROPER. Please help.

 

[Special-K99]

Use a Helper column
in E1
=PROPER(D1)
and copy down column E

Copy column E
Paste Values to column E (same column!)
Delete column D

 

[Fernesto48]

Worked like a charm. Many thanks!

 

[lenze]

OR if you don't want a Helper column, use code

Sub FixMe()
With Range("D2:D" & Cells(Rows.Count,"D").End(xlUp).Row
   .value= Proper(.Value)
End With
End Sub

lenze

 

[Fernesto48]

Thanks lenze; I really appreciate the quick response to my questions. You guys are great!