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.

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".

Download: PROPER Function

Leave a Reply