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


Change text strings to lowercase, uppercase, proper case...

Kutools for Excel's Change Case utility can help you to change the text strings to uppercase, lowercase, proper case, sentence case and toggle case as you need. Click to download Kutools for Excel!

doc change to lowercase 12


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


office tab pic

Layoff season is coming, still work slowly?
-- Office Tab boosts your pace, saves 50% work time!

  •  Amazing! The operation of multiple documents is even more relaxing and convenient than single document;
  •  Compared with other web browsers, the interface of Office Tab is more powerful and aesthetic;
  •  Reduce thousands of tedious mouse clicks, say goodbye to cervical spondylosis and mouse hand;
  •  Be chosen by 90,000 elites and 300+ well-known companies!
Full feature, Free Trial 30-day          Read More             Download Now!
 

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

 

Kutools for Excel

300 advanced tools,solve  1500 work scenarios

solve 80% Excel puzzles, increase 80% productivity

Help you Get Promotion,
Increase Salary!

Choice by 110,000 elites, 300+ well-known companies

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 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 80% Excel puzzles, save 80% work time.

pic beach
  •  Get a promotion and increase salary are not faraway;
  •  Contains 300 advanced features, solve 1500 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!
 
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 · 2 years ago
    Simple online tool for convert case
    Convert Case
  • To post as a guest, your comment is unpublished.
    Prabhukalyan Dhal · 2 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 · 3 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
  • To post as a guest, your comment is unpublished.
    fatima · 3 years ago
    Thank you so much i learnt what i wanted to know in excel
  • To post as a guest, your comment is unpublished.
    Jessica Vu · 4 years ago
    Thanks very much. It is so useful & easy to understanding. :-)
  • To post as a guest, your comment is unpublished.
    sharad · 4 years ago
    thanks,
    your suggestion very helpful
  • To post as a guest, your comment is unpublished.
    Sasikumar · 4 years ago
    Dear sir,

    when i strat to enter in the excel column i expected only uppercase using some formula. Please answer me
  • To post as a guest, your comment is unpublished.
    Sagar Jadhav · 4 years ago
    Thank you Very much it's very easy use ....... :-)
  • To post as a guest, your comment is unpublished.
    Ola · 4 years ago
    Can anybody help please? I am trying to perform vlookup and is coming as #N/A, i can confirm that what i am looking for actually exist in the column
  • To post as a guest, your comment is unpublished.
    Rsilva · 4 years ago
    very useful and easy

    thank you
  • To post as a guest, your comment is unpublished.
    ATULCHANDRA · 4 years ago
    VERY USEFUL ANSWER WITH MULTIPLE OPTION.
  • To post as a guest, your comment is unpublished.
    PHILEMON · 4 years ago
    THAT FOR MAKING ME UNDERSTAND
  • To post as a guest, your comment is unpublished.
    KIRAN · 4 years ago
    IT WAS USEFULTHANK YOU :) [/b]
  • To post as a guest, your comment is unpublished.
    parvathi arungopal · 4 years ago
    thanks for your good answer
  • To post as a guest, your comment is unpublished.
    mckillio · 4 years ago
    This didn't do anything, my cell (F2) just says =LOWER(E2). Does this have to be columns A and B?
  • To post as a guest, your comment is unpublished.
    Diljith · 4 years ago
    This looks heavily complex process. I am saying this for those who love shortcuts and less brain burns. thing is simple, copy the cell which you want to change the case, paste in a new blank word document, change its case and copy and paste it back into excel,BINGO !!!!...you're done
  • To post as a guest, your comment is unpublished.
    Nandu · 5 years ago
    Is there a short key for this ??
  • To post as a guest, your comment is unpublished.
    naim · 5 years ago
    how to set uppercase text with number.
    for example : jun-14
    • To post as a guest, your comment is unpublished.
      Rohit Karle · 5 years ago
      U just need to have a single quote(') for the numbers which are date.
      Eg. 'jun-14
      Use Formula =UPPER(CELL NUMBER).
      If it is other than date and all, You don't need to have single quote.
  • To post as a guest, your comment is unpublished.
    Jeanne B. · 5 years ago
    There is an easier way. In Excel, copy the entire column. Launch Word. Make new document. Paste. Use Word's case change button to change case. Select all. Copy. Return to Excel. Paste.


    Or... MAYBE EXCEL COULD INSTALL A CASE CHANGE BUTTON?
  • To post as a guest, your comment is unpublished.
    Basha · 5 years ago
    Very Helpful.

    Thank You
  • To post as a guest, your comment is unpublished.
    Madhuri · 5 years ago
    how to small letters change to capital letter in key board excel 2007
  • To post as a guest, your comment is unpublished.
    John Smith · 5 years ago
    Thanks a lot. you have done a great job. :-) :-) :-) this is an great article
  • To post as a guest, your comment is unpublished.
    Nas · 5 years ago
    What is the next step after the below comment?
    Note: This method can only change all the uppercase letters into lowercase in a new range, so you may have to take a further step to replace the uppercase letters with the lowercase letters.


    --------------------------------------------------------------------------------
    • To post as a guest, your comment is unpublished.
      tester · 5 years ago
      [quote name="Nas"]What is the next step after the below comment?
      Note: This method can only change all the uppercase letters into lowercase in a new range, so you may have to take a further step to replace the uppercase letters with the lowercase letters.


      --------------------------------------------------------------------------------[/quote]
      copy ---> paste special ----> values
  • To post as a guest, your comment is unpublished.
    asad · 5 years ago
    Thanks. Great article. MS should use this on their documentation instead
  • To post as a guest, your comment is unpublished.
    Lisa B · 5 years ago
    Or, use function =Proper(cell) to have capitals for first letter of names, cities, etc...
    • To post as a guest, your comment is unpublished.
      Bryan · 5 years ago
      This is an even Faster way to do it using VBA instead of excel functions.

      Sub LOWER_CASE()
      Addr = Intersect(ActiveSheet.UsedRange, Selection).Address
      Range(Addr) = Evaluate("IF(LEN(" & Addr & "),LOWER(" & Addr & "),"""")")
      End Sub

      Go to developer tab>macros>(type a name for the new macro)>create. and paste above code, now every time you run the macro it will change the case of the current selection to lowercase.

      Note. if you want to use it for UPPER or Proper case, you only have to replace all the "LOWER" ' s in the code with PROPER or UPPER depending of what you need.
      • To post as a guest, your comment is unpublished.
        anna · 3 years ago
        sometimes using VBA is more confusing than excel function, especially for Excel amateur like me lol