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:





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.

Using the PROPER function to convert text to title case

Follow us on

Facebook  Twitter  You Tube 

Other Text Functions

Excel 2010 Superhero Course