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

Get FREE Advanced Excel Exercises with Solutions!

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.

Overview Image to Change Upper Case to Lower Case in Excel


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.

Dataset to Change Upper Case to Lower Case in Excel


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.

Using LOWER Function to Change Upprcase to Lowercase in Excel

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.

selecting LOWER Function from the Formula Tab

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.

 Typing Function Argument in Text Box

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.

Result after using LOWER Function from Formula Tab

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

Pasting Copied Cells

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

Deleting Helper Column

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

Result after Deleting Helper Column

Read More: How to Change Lowercase to Uppercase in Excel


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.

change upper case to lower case using Flash Fill

Read More: How to Change Case for Entire Column in Excel


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.

Selecting Visual Basic from Developer Tab

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.

Inserting 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

VBA Code to Change Upprcase to Lowercase in Excel

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.

Selecting Macros

At this point, a Macros window will appear.

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

Running Code

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

Result after Running VBA Code

Check out the following GIF for a better understanding.

Running VBA Code


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.

Copying Name Column

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

Selecting Lowercase from Word to Change Upprcase to Lowercase in Excel

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

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

Copying Names from Word

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

Result after using Microsoft Word

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.

Using Data Validation Feature

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

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

Selecting Settings in the Data Validation dialog box

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.

selecting items in error alert window

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.

Typing Name in Lowercase

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

Result after Using Data Validation Feature to change uppercase to lowercase in Excel


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.

Inserting Power Query to Change Upprcase to Lowercase in Excel

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

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

Clicking OK in Create Table Dialog Box

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.

Selecting Lowercase from Power Query

Therefore, you can see a lowercase column.

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

loading Data from Power Query

Then, an Import Data dialog box will appear.

  • Select New Worksheet >> click OK.

Selecting New Worksheet

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

Result after using Power Query to Change Upprcase to Lowercase in Excel

Read More: How to Change Lowercase to Uppercase with Formula in Excel


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.

Using PROPER Function


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.

Use of UPPER Function


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.


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.


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo