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.
I am aware of the PROPER function but am not using it correctly. Any assistance would be greatly appreciated.