Changing Text Format

[sandzor]

I am working with a spreadsheet which contains employee names and addresses. Everything was initially entered in Capital letters. I would like the easiest way to reformat my cells so that the text has only the first letter of each word capitalized.

I am aware of the PROPER function but am not using it correctly. Any assistance would be greatly appreciated.

 

[Joe4]

If the data were in cell A1, then in the next column over, simply enter
=Proper(A1)

You can then do a Cut / Paste Special Values only if you want to make those formulas values and delete the original data.

 

[Aladin Akyurek]

Try also free ASAP Utilities from

http://asap-utilities.com