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

Method 1 – Applying LOWER Function

  • Type the following formula in cell E5.
  • Press ENTER.

Therefore, you will see the result in cell E5.

  • Drag down the formula with the Fill Handle tool.

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.

  • Click on cell E5 >> go to the Formulas
  • 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

Notice that cell E5 is showing the following formula.

  • Click OK.

 Typing Function Argument in Text Box

See the output in cell E5.

  • Drag down the formula with the Fill Handle tool.

See the complete Name in Lowercase column.

Result after using LOWER Function from Formula Tab

Remove the Helper Column

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

We will show how you can get rid of the helper column.

  • Select the column containing the formula, which is the Name in Lowercase
  • Press CTRL+C to copy this column.
Note: Remember to copy the column you want to stay in the dataset, not the helper column.

Copying a Column

  • Go to the Home
  • From the Paste group > select the Paste Values

Pasting Copied Cells

  • Select the helper column >> right-click on it.
  • Select the Delete option from the Context Menu.

Deleting Helper Column

We removed the helper column and we have the columns that we need.

Result after Deleting Helper Column

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

  • Type the name of cell D5 in lowercase in cell E5.
  • Go to the Data
  • From the Data Tools group >> click on the Flash Fill

See all the cells contain names in lowercase.

change upper case to lower case using Flash Fill

Method 3 – Applying VBA to Change Upper Case to Lower Case in Excel

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.
  • From the Insert tab >> select Module.

Inserting Module

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.

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.
  • Save the code >> return to our Worksheet.
  • Run the code; we will select the Name in Lowercase columns >> go to the Developer tab >> select Macros.

Selecting Macros

A Macros window will appear.

  • Select the Sub procedure >> click on Run.

Running Code

You can see the selected column now has names in lowercase.

Result after Running VBA Code

Check out the following GIF for a better understanding.

Running VBA Code

Method 4 – Using Microsoft Word

  • Select the Name in Uppercase column excluding the column header.
  • Press CTRL+C to copy.

Copying Name Column

  • Open Microsoft Word, and paste the copied cells by pressing CTRL+V.
  • Go to the Home tab >> select the Change Case (Aa) icon >> select Lowercase.

Selecting Lowercase from Word to Change Upprcase to Lowercase in Excel

You can see the column has names in lowercase.

  • Copy these names by pressing CTRL+C.

Copying Names from Word

  • 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

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

  • Select cells E5:E15 >> go to the Data
  • From the Data Validation group >> select Data Validation.

Using Data Validation Feature

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

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

selecting items in error alert window

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.

  • Press ENTER.

Typing Name in Lowercase

We completed the Name in Lowercase column by typing the name in lowercase.

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

Method 6 – Using Power Query to Change Upper Case to Lower Case in Excel

  • Insert Power Query, we will select the entire dataset >> go to the Data
  • From the Get & Transform Data group >> select From Table/Range.

Inserting Power Query to Change Upprcase to Lowercase in Excel

A Create Table dialog box will appear.

  • Make sure the My table has headers checkbox is marked >> click OK.

Clicking OK in Create Table Dialog Box

See the Power Query.

  • Select the Name in Uppercase column >> go to the Add Column
  • From the Format group >> select Lowercase.

Selecting Lowercase from Power Query

See a lowercase column.

Go to the Home tab >> click on Close & Load To.

loading Data from Power Query

An Import Data dialog box will appear.

  • Select New Worksheet >> click OK.

Selecting New Worksheet

See the dataset having the lowercase column.

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

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.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
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