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