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!

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
=UPPER

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.

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

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.

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.

3 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.
    But
    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

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard