Fixing Improper Capitalization in Excel Using the Proper Function

Suppose we wish to clean up names that are not in a proper case, we can use a simple formula based on the PROPER function.

The PROPER function will help us convert text into the proper case, if required. We can use it to capitalize each word in a given string. Using the function will not affect numbers and punctuations. It will convert all other letters to lowercase.

Things to remember about the PROPER Function
The first letter of every word, letters following numbers, or other punctuation are converted to uppercase by the PROPER function. It may be in places that we may not expect. For example, the function converts the “s” in the text string “Bob’s Boat” to uppercase (i.e. “Bob’S Boat”).
Numbers and punctuation characters are not affected.

excel properexcel trickexcel capitalization