Change text to upper, lower, or proper (normal) font

If you need to quickly change the text case to uppercase, lowercase, or proper (normal) case, use Flash Fill instead of retyping all the text.

For example, column A has a list of names in lower case. Here's how you can change the names to proper case.

  1. In cell B2 or the column next to your data, type the first and last name with the first letter in each name capitalized and press Enter.

    List of names in lower case

  2. Press Ctrl+E, or click Data > Flash Fill.

    Using Flash Fill, all the names in column B are now in Proper case

Flash Fill automatically fills in the rest of the names in column B, in the proper case.

Inconsistent capitalization? Use functions

Flash Fill works best on consistent data and doesn’t work on text that’s mistyped like this.

A column of names with inconsistent capitalization

With inconsistent text, use functions to change the case of existing text. Since all of the following functions work the same, we’ll see how to use just one of them.

Change text to proper case with the PROPER function

  1. To change Annik’s name to proper case, select cell B1. Type =PROPER(A1), and press Enter.

    List of mistyped names in colulmn A, and a name in proper case in cell B1

  2. To copy the formula down through cell B5, double-click the green square in the lower-right corner of cell B1.

The names in column B are all in proper case.

Formula copied down column B, all names now in proper case

Get rid of the first column

Just deleting the column of mistyped names might result in formula errors (#REF!). Here's how to remove the column:

  1. Copy the names in column B by dragging down the column and pressing Ctrl+C.

  2. Right-click cell A1.

  3. Click Paste Special > Values > OK to paste the names in column A without the formulas.

  4. Select column B.

  5. Right-click the selection, and pick Delete > Entire Column > OK.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!