How to Change Text Case in Excel?
Tags: changetextcaseinexce, exceltutorials, excel
Published: 2021-11-16 04:06:36

---
title: How to Change Text Case in Excel?
published: true
date: 2021-11-12 14:33:00 UTC
tags: ChangeTextCaseinExce,ExcelTutorials,Excel
canonical_url: https://geekexcel.com/change-text-case-in-excel-easy-and-quick-steps-in-excel-365/
---

## 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.

![](https://geekexcel.com/wp-content/uploads/2020/07/nv5.png)

### 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.

![](https://geekexcel.com/wp-content/uploads/2020/07/nv6.png)

### 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.

![](https://geekexcel.com/wp-content/uploads/2020/07/nv7.png)

## 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.

![](https://geekexcel.com/wp-content/uploads/2020/07/nv8.png)

**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.

![](https://geekexcel.com/wp-content/uploads/2020/07/nv9.png)

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

![](https://geekexcel.com/wp-content/uploads/2020/07/nv10.png)

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

![](https://geekexcel.com/wp-content/uploads/2020/07/nv11.png)

### Text.Upper Power Query Function:

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

![](https://geekexcel.com/wp-content/uploads/2020/07/nv12.png)

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

![](https://geekexcel.com/wp-content/uploads/2020/07/nv13.png)

### 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.

![](https://geekexcel.com/wp-content/uploads/2020/07/nv14.png)

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

![](https://geekexcel.com/wp-content/uploads/2020/07/nv16.png)

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.**](https://geekexcel.com/) Keep Learning!!