The PROPER function capitalizes the first letter of each word in a text and converts all other letters to lowercase.
Formula:
= PROPER(Text)
Explanations:
The text is required, the text string that you want to convert the first letter in each word to uppercase, and all other letters to lowercase.
Cautions:
All the first letters will be converted including the connection words (e.g., a, to, on …).
Example: Change all words' first letters in text string "how to use proper functioN" to uppercase and all other letters to lowercase
=PROPER(A2)
The result returns "How To Use Proper Function".
