PROPER Function in Excel – Convert to Proper Case in Excel

PROPER Function in Excel converts all the supplied character strings to proper case i.e. starting letter of every word in a sentence will be in upper case and rest all other letter in a word will be in lower case.

 

Syntax of PROPER Function in Excel:

Where text argument is the text that you want to convert into proper case.

 

Example of PROPER Function in Excel:

Formula:

In all of the above examples all the characters are converted into proper case.so the result will be

Result: