Method 1: Excel functions to change text to lowercase

Microsoft Excel supports the Lower function to change any kinds of text strings to lowercase, please do as this:

1. In the adjacent blank cell D1, enter or copy the formula

and press Enter key to get the first result. See screenshot:

2. Then, select the cell D1 and drag the fill handle down to the cells where you want to apply this formula, and all the text strings have been converted to lowercase letters, see screenshot:

3. And then, you should copy the converted cells and paste them to the original cells as values format as you need.

Notes:

To convert the text strings to uppercase, please apply this formula:

To convert the text strings to proper case which means to capitalize the first letter of each word, please apply this formula:

Method 2: Flash Fill feature to change text to lowercase

In Excel 2013 and later version, there is a handy utility – Flash Fill, with this feature, you can quickly solve this task as well.

1. Insert a blank column adjacent to your data that you want to change case, and then, enter the first text string that you want to use. For example, I will type the text string with lowercase in cell B2, see screenshot:

2. After typing the proper formatted text string and then select it, then click Home > Fill > Fill Flash, and the remaining cells in this column will be filled with lowercase text strings, see screenshot:

Notes:

1. To get all uppercase text, please type the uppercase text into the first cell, and then apply the Flash Fill function;

2. To get all proper case text, please type the text strings with first letter capitalized for each word into the first cell, and then apply the Flash Fill function;

Method 3: VBA code to change text to lowercase

The following VBA codes also can help you to change the text string cases to your need, and the converted results will be replaced the original values directly.

1. Hold down the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: Change text strings to lowercase:

Sub LCase()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Rng.Value = VBA.LCase(Rng.Value)
Next
End Sub

3. And then, press F5 key to run this code, in the popped out prompt box, select the range of cell you want to convert case, see screenshot:

4. Then, click OK button, and all text strings in the selected cells have been converted to lowercase, see screenshot:

Notes:

Sub UCase()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Rng.Value = VBA.UCase(Rng.Value)
Next
End Sub

Sub ProperCase()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Rng.Value = Application.WorksheetFunction.Proper(Rng.Value)
Next
End Sub

Method 4: Kutools for Excel to change text to lowercase

If you have Kutools for Excel installed, its Change Case tool can help you change all text strings to lowercase, uppercase, proper case, sentence case and toggle case in cells directly. Click to download Kutools for Excel! Please see below demo:

After installing Kutools for Excel, please do as this:

1. Select the cells that you want to change case, and then click Kutools > Text > Change Case, see screenshot:

2. In the Change Case dialog box, select lower case option, and then, click OK or Apply button, all the text strings have been converted to lowercase you desired, see screenshot: