tech on the net

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

Type of Function

Worksheet Function Example

Let's take a look at an example to see how you would use the PROPER function in a worksheet:

Microsoft Excel

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"