Excel: Proper Function
In 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.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:

Based on the Excel spreadsheet above:
=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"
