Microsoft Excel Functions & Formulas

Use the PROPER function to convert initial

characters from lowercase to uppercase

To convert the first letter in each word to uppercase and all other

letters to lowercase, the PROPER function is used. This function

capitalizes the first letter in a text string and any letters that follow

characters other than a letter (such as a space). All other letters

will be changed to lowercase.

This function has the following syntax:

PROPER(text)

text: Text enclosed in quotation marks, a formula that returns

text, or a reference to a cell that contains the text that should

have an initial capital letter.

4

To convert a text string to proper case:

1. In cells A2:A7 type ...