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:

PROPER(text)

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

 

Example of PROPER Function in Excel:

Formula:

PROPER Function in Excel 1

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

Result:

PROPER Function in Excel 2

 

previous PROPER Function in Excel                                                                                                                 next_small PROPER Function in Excel