Chat with us, powered by LiveChat

Change Case in Excel

How to Use UPPER, LOWER, and PROPER Functions in Excel

Change Case in Excel

The UPPER, LOWER, and PROPER text functions allow you to take a string of text from one cell and manipulate its capitalization in a separate cell.

UPPER Function

The UPPER function changes text to all uppercase letters. The syntax looks like this: =UPPER(text).

  1. Click in the cell where you want to insert the function.
  2. Click the Formulas tab.
  3. Click the Text Function button.
  4. Select UPPER.
    The UPPER Functions

    The Function Arguments dialog box opens. Here’s where you need to specify the cell you want to modify.

  5. Select the cell that contains the text you want to change to uppercase.
  6. Click OK.
    The UPPER Functions

The text from the specified cell is displayed in the current cell in all uppercase letters.

LOWER Function

The LOWER function changes text to all lowercase letters. The syntax looks like this: =LOWER(text).

  1. Click in the cell where you want to insert the function.
  2. Click the Text Function button on the Formula tab.
  3. Select LOWER.
    The LOWER Functions

    The Function Arguments dialog box opens. Here’s where you need to specify the cell you want to modify.

  4. Select the cell that contains the text you want to change to lowercase.

    Any characters in the cell that aren’t letters will not be affected.

  5. Click OK.
    The LOWER Functions

The text from the specified cell is displayed in the current cell in all lowercase letters.

PROPER Function

The PROPER function capitalizes just the first letter in each word of a text string. The syntax looks like this: =PROPER(text).

Because the syntax for these text functions is quite simple, you may find it easier to type it manually instead of using the Function Arguments dialog box.

  1. Click in the cell where you want to insert the function.
    The PROPER Functions
  2. Type =PROPER(), entering the cell you want to modify in the parentheses.
  3. Press Enter when you’re finished entering the formula.
    The PROPER Functions

The text from the specified cell is displayed in the current cell and only the first letter of each word is capitalized.

FREE Quick Reference

Click to Download