How to Use PROPER Function

The PROPER function capitalizes the first letter of each word in a text and converts all other letters to lowercase.


= PROPER(Text)


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.


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


The result returns "How To Use Proper Function".

Download: PROPER Function

Leave a Reply