Change text to upper, lower, or proper (normal) font in Excel 2016 for Windows

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.

In the following example, column A has a list of names in lowercase, which you can change 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 then press Enter.

    List of names in lower case

  2. Press Ctrl+E, or on the Data tab, in the Data Tools group, click 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. Because all of the following functions work the same, we’ll show 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 then 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

Remove the first column

Simply deleting the first column of mistyped names might result in formula errors (#REF!) because the data in column B relies on the data in column A. To prevent this error, you need to change the information to text.

  1. Select the names in column B, and then press Ctrl+C.

  2. Right-click cell A1, and then click Paste Special.

  3. Under Paste, click Values, and then click OK to paste the names in column A without the formulas.

  4. Select the names in column B.

  5. Right-click the selection, click Delete, select Entire Column, and then click 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!

×