from a post of mine on the 23rd.
if you have formulas, use this instead or you will wipe out the formulas

Sub makeproper()
With ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants)
..Value = Application.Proper(.Value)
End With
End Sub


--
Don Guillett
SalesAid Software

"dumbfounded" wrote in message
...
I have a spreadsheet containing data to make mailing labels. The whole
thing
was entered in caps. I need to change it to the Proper style ( the first
letter is capitalized and the rest lower case). How can I do this?