Change Upper Case to Lower Case in Excel (6 Easy Ways)

Looking for ways to change upper case to lower case in Excel? Do not worry, we are here for you. In this article, we will describe 6 easy ways to change capital letters to small letters.

You might need to convert upper case data into the lower case while working with text data, such as names or addresses, which is frequently the case. Excel makes it incredibly simple to go from upper case to lower case or vice versa.

Here, we will also learn how you can convert lower case to upper case, and upper case to proper case in Excel.

In the following overview image, you can see that we have changed upper case to lower case in Excel. So let’s walk through the article to do the task by yourself.

Change Upper Case to Lower Case in Excel: 6 Easy Methods

In the following dataset, you can see that we have the Car Brand, User Profession, and Name in Uppercase columns. Now we will change the Name from Uppercase to lowercase. To do so, we will go through 6 methods.

Here, we used Excel 365. You can use any available Excel version.

1. Applying LOWER Function

You can change uppercase into lowercase by using the LOWER function. To do this follow the below steps.

First of all, type the following formula in cell E5.

=LOWER(D5)

After that, press ENTER.

Therefore, you will see the result in cell E5.

Now, drag down the formula with the Fill Handle tool.

As a result, you can see the complete Name in Lowercase column.

Inserting LOWER Function from Formula Tab

You can also insert the LOWER function from the Formula tab.

To do so, click on cell E5 >> go to the Formulas
Then, from the Text group >> click on LOWER.

At this point, a Function Arguments dialog box appears.

Type D5 in the Text

Here, you can notice that cell E5 is showing the following formula.

=LOWER(D5)

At this point, click OK.

Therefore, you will see the output in cell E5.

Now, we will drag down the formula with the Fill Handle tool.

As a result, you can see the complete Name in Lowercase column.

Remove the Helper Column

Here, we have two name columns, one is the Name in Uppercase, which is the helper column. And the other is Name in Lowecase. Once we have the complete Name in Lowercase column, we do not need the helper column anymore.

Thus, we will show how you can get rid of the helper column.

First of all, we will select the column containing the formula, which is the Name in Lowercase
We will press CTRL+C to copy this column.

Note: Remember to copy the column that you want to stay in the dataset, not the helper column.

Copying a Column

Then, we will go to the Home
From the Paste group > select the Paste Values

Now, we will select the helper column >> right-click on it.
Then, we will select the Delete option from the Context Menu.

Thus, we have removed the helper column and we have the columns that we need.

2. Use of Flash Fill Feature to Change Upper Case to Lower Case in Excel

In this method, we will use the Flash Fill feature to change upper case to lower case in Excel. Flash Fill is a relatively handy feature in Excel that fills cells automatically for you based on patterns it detects.

First of all, we will type the name of cell D5 in lowercase in cell E5.
Then, we will go to the Data
From the Data Tools group >> click on the Flash Fill

As a result, you can see all the cells contain names in lowercase.

3. Applying VBA to Change Upper Case to Lower Case in Excel

In this method, we will use VBA Code to change uppercase to lowercase in Excel.

First of all, we will go to the Developer tab >> select Visual Basic.

This will open a VBA Editor window.

Note: You can press the ALT+F11 keys to open the VBA Editor window.

Then, from the Insert tab >> select Module.

After that, type the following code in the Module.

Sub Change_Uppercase_to_Lowercase()
For Each i_cell In Selection
If Not i_cell.HasFormula Then
i_cell.Value = LCase(i_cell.Value)
End If
Next i_cell
End Sub
VBA Code

Code Breakdown

Sub Change_Uppercase_to_Lowercase()

We take Change_Uppercase_to_Lowercase as the Sub procedure.

For Each i_cell In Selection

We use For loop to run the loop through each selected i_cell.

If Not i_cell.HasFormula Then

We use the If statement to check whether i_cell contains a formula or not.

i_cell.Value = LCase(i_cell.Value)

End If

When the value of i_cell will equal the value of LCase i_cell, then the If statement will exit.

Next i_cell

This line ends the For loop.

End Sub

This line ends the Sub procedure.

After that, we Save the code >> return to our Worksheet.
Now to run the code, we will select the Name in Lowercase columns >> go to the Developer tab >> select Macros.

At this point, a Macros window will appear.

Then, we will select the Sub procedure >> click on Run.

Thus, you can see the selected column has now names in lowercase.

Check out the following GIF for a better understanding.

4. Using Microsoft Word

Here, we will use Microsoft Word to change upper case to lower case in Excel.

First of all, we will select the Name in Uppercase column excluding the column header.
Then, we press CTRL+C to copy.

After that, open Microsoft Word, and paste the copied cells by pressing CTRL+V.
Then, we go to the Home tab >> select the Change Case (Aa) icon >> select Lowercase.

Therefore, you can see the column has names in lowercase.

Now, we will copy these names by pressing CTRL+C.

Finally, go to the Excel sheet >> select the cells where you want to input the copied cells >> press CTRL+V to paste.

Read More: How to Change Case in Excel Sheet

5. Use of Data Validation to Enter Text in Lower Case Only

Here, we will use the Data Validation feature to make a restriction for the users, so that the users only have to input data in lowercase.

First of all, we will select cells E5:E15 >> go to the Data
Then, from the Data Validation group >> select Data Validation.

At this point, a Data Validation dialog box will appear.

From Settings >> select Custom.
Mark the ignore blank box >> click on Error Alert.

Then, in the Error Alert window, mark Show error alert after invalid data is entered.

Select Stop as Style.
Type a Title >> type an Error message.
Then, click OK.

Now, if you try to type anything in uppercase, an error will pop up.

Click on Cancel >> type the name in lowercase.

At this point, no error message will pop up.

Then, press ENTER.

Here, we have completed the Name in Lowercase column by typing name in lowercase.

6. Using Power Query to Change Upper Case to Lower Case in Excel

In this case, we will use Power Query to convert uppercase to lowercase in Excel.

First of all, to insert Power Query, we will select the entire dataset >> go to the Data
Then, from the Get & Transform Data group >> select From Table/Range.

At this point, a Create Table dialog box will appear.

Then, make sure the My table has headers checkbox is marked >> click OK.

Thus, you can see the Power Query.

Select the Name in Uppercase column >> go to the Add Column
Then, from the Format group >> select Lowercase.

Therefore, you can see a lowercase column.

Now, go to the Home tab >> click on Close & Load To.

Then, an Import Data dialog box will appear.

Select New Worksheet >> click OK.

Therefore, you can see the dataset having the lowercase column.

How to Convert Upper Case to Proper Case in Excel

Here, we will show how you can convert upper case to proper case in Excel. The proper case is when the first letter of a word is in a capital letter, and the rest of the letters are in small letters.

We will use the PROPER function for this.

First of all, we will type the following formula in cell E5.

=PROPER(D5)

After that, press ENTER.

Therefore, you can see the result in cell E5.

Then, we drag down the formula with the Fill Handle tool.

As a result, you can see the complete Name in Propercase column.

How to Convert Lower Case to Upper Case in Excel

Here, we will show how you can convert lower case to upper case in Excel.

We will use the UPPER function for this.

First of all, we will type the following formula in cell E5.

=UPPER(D5)

After that, press ENTER.

Therefore, you can see the result in cell E5.

Then, we drag down the formula with the Fill Handle tool.

As a result, you can see the complete Name in Uppercase column.

Things to Remember

Using the LOWER function is simple and easy among other methods to change uppercase into lowercase.
You can use Flash Fill by pressing ALT + E In many cases this doesn’t work. Then you can use the procedure that we have described above.
Power Query is a very effective tool in Excel not only to change text patterns but also to organize data in various ways.

Download Practice Workbook

You can download the Excel file from the link below and practice the explained methods.

Change Upper Case to Lower Case.xlsm

Conclusion

In this article, we describe 6 easy ways to change uppercase to lowercase in Excel. In addition to this, we describe how you can convert upper case to proper case, and lower case to uppercase in Excel.

We extensively describe all the methods and tips and tricks of each method. We hope this article is helpful for you. Thank you for going through the article. If you have any queries or suggestions, please let us know in the comment section.

<< Go Back to Change Case | Text Formatting | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

Change Upper Case to Lower Case in Excel (6 Easy Ways)