spot_img

Change Case

 

To change the case of text in Excel, use LOWER, UPPER or PROPER. If you’re not a formula hero, use Flash Fill to change case in Excel.

1. Use the LOWER function in Excel to change the case of text to lowercase.

Lowercase in Excel

Note: double click the lower right corner of cell B1 to quickly copy this formula to the other cells.

2. Use the UPPER function in Excel to change the case of text to uppercase.

Uppercase in Excel

3. Use the PROPER function in Excel to change the first letter of each word to uppercase and all other letters to lowercase.

Proper Case in Excel

If you’re not a formula hero, use Flash Fill to change the case of text in Excel. In the example below, we are looking for a mix of proper case and uppercase.

4. First, tell Excel what you want to do by entering the correct city (proper case) and state abbreviation (uppercase) into cell B1.

Proper and Uppercase

5. On the Data tab, in the Data Tools group, click Flash Fill (or press CTRL + E).

Click Flash Fill

Result:

Change the Case of Text

Note: Flash Fill is not perfect and sometimes needs a little help. Visit our page about Flash Fill to learn more about this great Excel tool.

spot_img
Previous articleCalculated Field/Item in a Pivot Table – Easy Excel
Next articleCount Cells with Text in Excel