Video: How to change text case in Excel

Learn several ways of changing case in Excel: a special add-in, standard functions, or Flash Fill.

See all the ways you can change case of the values in Excel spreadsheets. Besides a special add-in that allows you to capitalize the first character in each cell, update the selected records to uppercase, lowercase, or proper case, you can see the standard functions you can use, and learn how to employ Flash Fill in Excel for this purpose.

How to change case in Excel: video transcript

In this video you'll learn how to change the selected values to uppercase, lowercase, proper case, and how you can capitalize the first character in each cell.

Unlike Microsoft Word, Excel doesn't offer any toolbar icons that change the case of your values in a click. This is why we provided such tool in our Cell Cleaner add-in.

Use Cell Cleaner add-in

Once you install the add-in, you'll find the Change Case icon under Ablebits Utilities tab in Excel. Now you only need to select the cells that you want to update.

You can change lowercase to uppercase or the other way round, capitalize each word, or even each cell. Once you select the necessary option, you can choose to back up the worksheet, and click Change case. That's it!
The quickest way to change case in Excel tables

Use Excel functions to change to lowercase, uppercase, or proper case

If you prefer to work with formulas, let's take a look at the functions you will need.

When you want to change lowercase to uppercase in Excel, add a helper column where you'll write your formula, and enter

Write the address of your first cell with a value in parenthesis. To quickly get this formula in all the cells below, select the cell and double-click the black plus sign you'll see in the bottom-right corner.
UPPER function will turn all the letters to upper case

The function you need to use to convert capital letters to lowercase in Excel is:

Add the cell address the same way.

If you don't want the text in all caps or in lowercase, use
=PROPER with the cell address in your table in Excel to capitalize the first letter of each word.

To convert the formulas to values, you'll need to select and copy them, then choose to paste special, values only to get your text the way you need it.

Employ Flash Fill in Excel: capitalize the first letter in the entire column

There is one more standard way to change case in the latest versions of Excel. The trick is to use a helper column right next to the original one.

You will need to type the first couple of values the way you need them: that is to give Excel an example of the case you want to see. Then either press Ctrl +E, or go to Data and click Flash Fill. It should get the idea and fill the entire column with the case you need.
Use Excel Flash Fill tool to change the case of the letters

Well, now that we looked at the main ways you can change case in Excel, I should mention two more options. You can select and copy your records, paste them to Word and use the options for changing case that are available there. Once you apply uppercase or lowercase, copy the results back to your table in Excel. Knowing the shortcuts will make this process a lot faster.

Finally, you can also automate the task and use a VBA macro. The process is not as hard as it may sound, please take a look at our blog post that describes it in detail.

You can find a link to our Text Toolkik for Excel in the description to this video, feel free to use the coupon code Preview to get a 15% discount.

I hope you'll find these hints helpful. If you have any questions or particular tasks, please share them as comments.

4 responses to "Video: How to change text case in Excel"

  1. Dattatray says:

    Hi I am looking for a forumla to completed the following calculation in a cell:

    Formula in C1 is:

    If B1=A1:A1000 then take value of B1 in C1 cell.
    If B1 is not equal to A1:A1000 then take higher value than B1 from A1:A1000 & show it in C1 cell.

    Please can you help me out with this formula

    • Hello Dattatray,
      Can you please describe your task in more detail? Are you trying to compare numbers in column B to numbers in column A, e.g. B1 to A1, B2 to A2 etc.? If they are not the same, do you want to show the corresponding value from column A? If you want to show it only if it is higher, what should the formula show if the number in column A is lower?

  2. Majeed says:

    Good afternoons I am want change Cade my email please I looking advance

  3. Keith Morse says:

    This does not work for me. I highlight the cells, select change case and proper case and the dialog box comes back saying "No cells have been processed."

Post a comment

Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)