Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How To Change Uppercase To Lowercase In Microsoft Excel?

Supposing you receive an Excel report with all text strings in uppercase letters, it will be easier to read if you can change these uppercase letters into lowercase in Excel. The following tricks can quickly change all uppercase letters into lowercase in Excel.
 

Change the text strings from uppercase to lowercase / proper case / sentence case:

The Kutools for Excel's Change Case utility can help you to convert the text strings to uppercase, lowercase, proper case, sentence case and so on quickly and easily as you need.

doc change to lowercase 13

Download and free trial 60-day

 

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

=LOWER (A2)

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

doc change to lowercase 1

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:

doc change to lowercase 2

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

doc change to lowercase 3

Notes:

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

=UPPER(A2)

doc change to lowercase 4

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

=PROPER(A2)

doc change to lowercase 5

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:

doc change to lowercase 6

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:

doc change to lowercase 7

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;

Office Tab - Browsing, Editing multiple Documents in single window, like Google Chrome, Firefox...

hot doc
office tab demo
  • Tabs for Word, Excel, Powerpoint, Publisher, Access, Project and Visio
  • 90,000+ Office users' choice!
  • Full feature free trial 45-day! No Credit Card Required!
  • Full money back within 60 days!
 

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:

doc change to lowercase 8

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

doc change to lowercase 9

Notes:

Change text strings to uppercase, please copy and paste this VBA code into the Module:

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

Capitalize the first letter of each word, please copy and paste this VBA code into the Module:

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

 

Kutools for Excel

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.

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:

doc change to lowercase 10 1

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:

doc change to lowercase 11

Tips: This Change Case utility also can help you to change the text strings to uppercase, proper case, sentence case and toggle case, please see the below gif picture:

doc change to lowercase 12

Download and free trial 60-day

 

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    toolnx · 1 years ago
    Simple online tool for convert case
    Convert Case
  • To post as a guest, your comment is unpublished.
    Prabhukalyan Dhal · 1 years ago
    Is there any simple method without using any formula within the same excel sheet ?
  • To post as a guest, your comment is unpublished.
    Raghavendra · 2 years ago
    My friends Upper case and Lower case formula is =UPPER(COLOM &ROW ) ENTER
  • To post as a guest, your comment is unpublished.
    sandeep verma · 3 years ago
    how to ms excel in current cell & all selected cell upper case & lower case formula use in this work sheet . because used short key of sued key board .

    than show result.
  • To post as a guest, your comment is unpublished.
    sandeep verma · 3 years ago
    advance excel note book .

    warms regard.

    sandeep verma

    Thank's