The PROPER Function in EXCEL Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. Converts all other letters to lowercase letters.
The syntax for The PROPER Function: PROPER(text)
