If you have an address in cell A1, you can enter =proper(a1) in cell B1.

"dumbfounded" wrote:

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?