How to Change Text Case in Excel?

Change Text Case in MS Excel:

In Microsoft Excel, there is no shortcut for changing the text case of data. But luckily, there are some built-in functions like UPPER , LOWER , and PROPER Functions available in it. You can use this built-in formula to change the text case in Excel 365. In this tutorial, we will learn some easy and quick steps to Change the Text Case of specific data in Excel.

How to Change Text Case with Excel Formulas?

The following three Excel Formulas are used to change the Text Case of any data in a spreadsheet.

1. Lower Function
2. Upper Function
3. Proper Function

Lower Function to Change Text Case:

• To Change the Text case of data into Lower Case, You need to use the following formula.
• ” =LOWER(Text) ” – It takes one argument to change it as Lower Case.
• Refer to the next example image.

Upper Function to Change Text Case:

• This formula is used to change the data into UPPER Case.
• ” =UPPER(TEXT) ” – It takes one argument to change it as Upper case.

Proper Function to Change Text Case:

• This Function changes the text into the proper case, which means a word starts with a capital letter and is followed by small letters.
• ” =PROPER(TEXT) ” – this Formula is used to change the data into Proper Case.

Changing Text case using Flash Fill in Excel:

• Flash Fill is another simple method to Change the Text Case of the data.
• To do this, you need to enter the data with mixed cases in one column, and then you have to give the example data that you want to see as a result on the right of your original data.
• To enable Flash Fill for the selected data, you have to press CTRL + E keys, and Now it will repeat the pattern for the remaining rows to fill the changed text case data.

Flash Fill is used for simple data transformation like Changing the Text Case into Upper , Lower , and Proper.

How to Change Text Case using Power Query?

You can use Power Query Options to Change the Text Case of the data. The categories in the Power Query function are:

1. Text.Lower Function
2. Text.Upper Function
3. Text.Proper Function

Text.Lower Power Query Function:

• Select the Data Tab on Ribbon Command. Select From Table or Range icon to view the Power Query Editor Dialog Box in Excel. In that dialog box, you can apply the Case Transformation for your data.

• In Power Query Editor, You need to Select the Column to transform the data into Lower case.
• On the Add Column Tab, Click Format option and select the lower case option from the menu.

• It will use the Text.Lower Function to transform the data into lower case.
• ” =Table.AddColumn(#”Changed Type”, “lowercase”, each Text. Lower([Name]), type text ) ” is the formula shown in the formula bar.
• Now, it will display the transformed data in another column.

Text.Upper Power Query Function:

• The Steps are the same as above but you need to Select Upper Case from the menu list.

• It will create a new column with transformed data like below.

Text.Proper Power Query Function:

• In this case, you have to Select Capitalize Each Word Option from the Format menu list to Change the Text Case into Proper.

• It will create a new column with transformed data like below.

The above examples are shown the steps to Change Text Cases of data into Lower, Upper, and Proper data.

Wrap-Up:

In the above article, you can understand the steps to Change Text Cases using Formulas , Flash Fill , and Power Query Functions in Excel 365 with the best practice examples. Kindly drop your suggestions/queries in the below comment section. Thanks for visiting Geek Excel. Keep Learning!!