Proper in excel: How to use PROPER worksheet function

Excel version in which Proper function can work:

PROPER in excel functions will work in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones.

About function Proper in excel:

PROPER function in excel converts all texts to propercase. If the characters are other than letters , they are unaffected by using this function.

Syntax for PROPER Function:

=PROPER(text)

Parameters:

Text: The word which you want to convert from.

Using PROPER function:

Proper function converts words to proper case. It converts every first letter of the word to Upper case. Assume B3, B4 and B5 are the cell reference respectively.

Words Formula Result
Where are you  =PROPER(B3) Where Are You
How are you  =PROPER(B4) How Are You
What are you doing  =PROPER(B5) What Are You Doing

proper in excel

These functions can be clubbed with any other functions in excel.

Leave a Comment