In Excel, the Proper function sets the first character in each word to uppercase and the rest to lowercase.
The syntax for the Proper function is:
Proper( text )
text is the string argument whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.
