The Excel Proper function converts all characters in a supplied text string to proper case (i.e. all letters that do not follow another letter are set to upper case and all other characters are lower case).
The format of the function is:
Note that, as well as the first letter of every word, letters following numbers or other punctuation are converted to upper case by the Excel Proper function. This may be in places that you might not expect. For example, the function converts the "s" in the text string "Bob's Boat" to upper case (i.e. "Bob'S Boat").
The spreadsheets below show four examples of the Proper function.
Further information and examples of the Excel Proper function are provided on the Microsoft Office website.