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 withnumber formattingremoved.
If you only want to capitalize the first word (i.e.
Numbers, punctuation, and spaces are not affected.
LOWER Function
The Excel LOWER function converts a text string to all lowercase letters.
Numbers, punctuation, and spaces are not affected.
PROPER Function
The Excel PROPER function capitalizes each word in a given text string.
Numbers, punctuation, and spaces are not affected.
