Using the PROPER, UPPER, and LOWER Functions

Contact Us or call 1-877-932-8228
Using the PROPER, UPPER, and LOWER Functions

Using the PROPER, UPPER, and LOWER Functions

The PROPER function is used to make the first letter in each word uppercase and all other letters lowercase. To use the PROPER function:

  1. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function Command
  2. In the Insert Function dialog box:
    1. Search on "PROPER" or, in the Or select a category drop-down box, select Text.
    2. Under Select a function, select PROPER.
    3. Click OK.PROPER
  3. In the Function Arguments dialog box:
    1. In the Text data entry field, enter the cell containing the text you wish to capitalize the first letters of.
    2. Click OK.OK Option

The UPPER Function

The UPPER function is used to make all letters in words uppercase.

  1. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function Command
  2. In the Insert Function dialog box:
    1. Search on "UPPER" or, in the Or select a category drop-down box, select Text.
    2. Under Select a function, select UPPER.
    3. Click OK.UPPER
  3. In the Function Arguments dialog box:
    1. In the Text data entry field, enter the cell containing the text you wish to make all uppercase.
    2. Click OK.OK Option

The LOWER Function

The LOWER function is used to make all letters in words lowercase.

  1. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function Command
  2. In the Insert Function dialog box:
    1. Search on "LOWER" or, in the Or select a category drop-down box, select Text.
    2. Under Select a function, select LOWER.
    3. Click OK.OK Option
  3. In the Function Arguments dialog box:
    1. In the Text data entry field, enter the cell containing the text you wish to make all lowercase.
    2. Click OK.Lowercase Text

The TRIM Function

Another text function you may use is the TRIM function. TRIM allows you to remove the spaces in phrases, leaving only single spaces between words.

Next