Excel Function: PROPER

The Excel function PROPER capitalizes the first letter of each word and changes all other letters to lowercase.

Usage:

=PROPER(text)


Example of use

Select the PROPER function and simply enter the text to convert:

proper function

The result after copy:

proper