Excel Tricks: Convert Lowercase to Uppercase in MS Excel with Shortcut. Convert Lowercase to Uppercase in MS Excel. It is not possible to directly convert upper case to lower case letters and lowercase to upper case letter in Excel itself. It may be possible with help of some macros. This formula converts the name in cell A2 from uppercase to proper case. To convert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference. Now, fill down the formula in the new column.
There are ways to change the case of text to uppercase, lowercase, or proper case in Microsoft Excel. Below are all of the various methods that can be used.
NoteThere is no keyboard shortcut to change the case of highlighted text in a cell.
Changing the case using functions
Three different functions can be used in Excel to change the capitalization of text in a cell. Below is an overview of each of these functions.
=LOWER( )
Using the lower function takes the value of any cell, and converts it to lowercase text. For example, if you wanted to show in cell B1 a lowercase version of the text in A1, you could type the below function into B1.
=PROPER( )
Using the proper function takes the value of any cell, and converts it to proper case. For example, if you wanted to show in cell B1 a proper case version of the text in A1, you could type the below function into B1.
=UPPER( )
Using the upper function takes the value of any cell, and converts it to uppercase text. For example, if you wanted to show in cell B1 an uppercase version of the text in A1, you could type the below function into B1.
TipOnce you've created any of the above formulas, you can use the Excel Fill Handle to copy the function into as many cells as needed.
Use Excel Flash Fill
Users who are using Excel 2013 and higher also have the option to use Excel Flash Fill to automatically fill cells to how you want them to be formatted. Below is an example of how Flash Fill can be used to complete text with the case you want to use.
Enter the text how you want it to appear. For example, in the picture, we have names in column A and want column B to use proper case for each of the names.
Once the properly formatted version of the text is inserted, press the keyboard shortcut Ctrl+E or click Data and then Flash Fill to fill out the remaining cells.
Once complete, each of the names should be in column B with the proper case.
Copy and paste
If none of the above solutions work, you can also copy and paste any text within Excel to another program with support for changing the case. For example, you could copy and paste text from Excel to Microsoft Word and use the shortcut key Shift+F3 to change text between uppercase, lowercase, and proper case.
TipUse our text tool to convert any text from uppercase to lowercase.
Additional information
- See our case, case sensitive, lowercase, and uppercase definitions for related links and information.