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"