Hi Cecile,

Try:

Sub Tester()
Dim rng As Range
Dim rCell As Range

Set rng = ActiveSheet.UsedRange

For Each rCell In rng.SpecialCells(xlCellTypeConstants, 2)
With rCell
.Value = Application.Proper(.Value)
End With
Next
End Sub

If you are unfamiliar with macros, see David McRitchie's Getting Started
with Macros and User Defined Functions notes at:

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


---
Regards,
Norman



"Cecile" wrote in message
...
Hi all, I have a spreadsheet (1000+ lines) which has a lot
of upper cases. How can I change the text to sentence case?
I tried looking at the PROPER function, but it doesn't
seem to do what I want.
Thanks in advance,
Cecile.