Make All Text Upper Case or Lower Case in Excel

Add to Favorites

How to quickly change all text to upper case or lower case in Excel.  This allows you to change the case of text without having to manually type in the text.

I will show you how to change the case of text and also how to make the results of the functions we will use actual text instead of function/formula output.

Also, check out our tutorial on how to capitalize first letter of every word in Excel.

Sections:

How to Quickly Make Text Upper Case in Excel

How to Quickly Make Text Lower Case in Excel

How to Make the New Text Actual Text instead of a Function

How to Quickly Make Text Upper Case in Excel

  1. Go to the desired text.
  2. In another cell, type =UPPER(A1) where A1 is the reference of the cell that contains the text you want to make upper case.
  3. View the result:

How to Quickly Make Text Lower Case in Excel

  1. Go to the desired text.
  2. In another cell, type =LOWER(A2) where A2 is the reference of the cell that contains the text you want to make lower case.
  3. View the result:

How to Make the New Text Actual Text instead of a Function

The problem with the above methods is that the output that we see that is now lower case or upper case is not actually text; it is the output of the UPPER and LOWER functions in Excel.  As such, we need to still have the original list of data in order to have the new list.

To remove the original list of data and keep the new list with either all upper case or lower case text we do this:

  1. Select the output of the UPPER or LOWER function:
  2. Hit Ctrl + C:

  3. Hit Alt +  E + S + V and then Enter. (to remove the copy outline you can hit the escape (Esc) key after you hit Enter)
  4. Now, we can delete the original column of data so that we only have one column of data.

    Note that these cells, after step 3, contain only text.  There is no more UPPER or LOWER function contained within these cells.  This allows us to do whatever we want with the contents of the new list.

Notes

The UPPER and LOWER functions are great text manipulation functions that you can use to quickly clean or update lists of data.  These functions will save you a ton of time, especially with large lists of data.

Don't forget to download the accompanying workbook so you can follow the examples above.


Excel Function: LOWER(), UPPER()
Downloadable Files: Excel File

Similar Content on TeachExcel
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...
Filter Data in Excel - AutoFilter
Macro: This free Excel macro filters data in Excel using the autofilter feature in an Excel macro...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a...
Convert Scientific Notation to Numbers in Excel
Tutorial: How to convert scientific numbers to show their full amount; this method also allows you t...
FV Function - Get the Future Value in Excel
Tutorial: The Future Value function (FV) in Excel will return the future value of an investment ba...
Tutorial Details
Excel Function: LOWER(), UPPER()
Downloadable Files: Excel File
Similar Content
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...
Filter Data in Excel - AutoFilter
Macro: This free Excel macro filters data in Excel using the autofilter feature in an Excel macro...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Excel Forum