The PROPER function capitalizes each word in a given text string. PROPER function takes just one argument, text, which can be a text value or cell reference. PROPER first lowercases any uppercase letters, then capitalizes each word in the provided text string. Numbers, punctuation, and spaces are not affected. PROPER will convert numbers to text with number formatting removed.
If a numeric value is given to PROPER, number formatting is removed. For example, if cell A1 contains the date June 26, 2021, date formatting will be lost and PROPER will return a date serial number as text:
The PROPER function automatically reformats text so that all words are capitalized. At the same time, it lowercases all other text.
If you also need to strip out extra spaces in the names, you can wrap PROPER in the...