Excel > Functions

PROPER Function

The PROPER function is used to convert the first character of each word in a cell to uppercase and the remaining characters to lowercase.

The syntax for the PROPER function is:

=PROPER(text)

Argument	Purpose
Text	The text you want to convert to proper case, usually entered as a cell reference

The example below shows the PROPER function being used to convert the text in cells A2 and A3 to proper case.

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Guides