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 |
These functions can be clubbed with any other functions in excel.