Skip to main content

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 as following screenshot shown. The following tricks can quickly change all uppercase letters into lowercase in Excel.


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;


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

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:


doc change to lowercase 12

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:

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 as you need.


Busy work on weekend, Use Kutools for Excel,
gives you a relaxing and joyful weekend!

On the weekend, the kids are clamoring to go out to play, but there is too much work surrounds you to have time accompany the family. The sun, the beach and the sea so far away? Kutools for Excel helps you to solve Excel puzzles, save work time.

pic beach
  •  Get a promotion and increase salary are not faraway;
  •  Contains advanced features, solve application scenarios, some features even save 99% work time;
  •  Become an Excel expert in 3 minutes, and get recognition from your colleagues or friends;
  •  No longer need to search solutions from Google, say goodbye to painful formulas and VBA codes;
  •  All repeated operations can be completed with only several clicks, free your tired hands;
  •  Only $39 but worth than the other people's $4000 Excel tutorial;
  •  Be chosen by 110,000 elites and 300+ well-known companies;
  •  30-day free trial, and full money back within 60-day without any reason;
  •  Change the way you work, and then change your life style!
 
Comments (34)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Simple online tool for convert case Convert Case
This comment was minimized by the moderator on the site
Simple online tool for convert case Case converter
This comment was minimized by the moderator on the site
Is there any simple method without using any formula within the same excel sheet ?
This comment was minimized by the moderator on the site
My friends Upper case and Lower case formula is =UPPER(COLOM &ROW ) ENTER
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
advance excel note book . warms regard. sandeep verma Thank's
This comment was minimized by the moderator on the site
Thank you so much i learnt what i wanted to know in excel
This comment was minimized by the moderator on the site
Thanks very much. It is so useful & easy to understanding. :-)
This comment was minimized by the moderator on the site
thanks, your suggestion very helpful
This comment was minimized by the moderator on the site
Dear sir, when i strat to enter in the excel column i expected only uppercase using some formula. Please answer me
This comment was minimized by the moderator on the site
Thank you Very much it's very easy use ....... :-)
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations