MS Excel: PROPER Function (WS)
In Microsoft Excel, the PROPER function sets the first character in each word to uppercase and the rest to lowercase.
Syntax
The syntax for the PROPER function is:
PROPER( text )
text is the string argument whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.
Applies To
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
Worksheet Function Example
Let's take a look at an example to see how you would use the PROPER function in a worksheet:
Based on the Excel spreadsheet above, the PROPER function would return the following:
| =PROPER(A1) | would return "Alphabet Soup" |
| =PROPER(A2) | would return "Tech On The Net" |
| =PROPER(A3) | would return "Alpha Beta" |
| =PROPER("excel") | would return "Excel" |