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.
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.
- 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"|