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

or
0
0
0
s2smodern

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 uppercase to lowercase in Excel with LOWER function

Change uppercase to lowercase in Excel with Kutools for Excel


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

With 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 convert uppercase to lowercase 7

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!

Change uppercase to lowercase in Excel with LOWER function


Using Microsoft Excel's Lower function is an easy way to change any kinds of text strings or letters to lowercase in one cell.

1. In the adjacent cell C1, enter the formula =LOWER (A1). See screenshot:

doc convert uppercase to lowercase 1

2. Press Enter key and the formula has been applied to the cell C1, then select cell C1, drag the fill handle over the range of cells that you want to apply this formula. And all of the uppercase text strings have been changed to lowercase strings. See screenshot:

doc convert uppercase to lowercase 2

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.


Change uppercase to lowercase in Excel with Kutools for Excel

If you have Kutools for Excel installed, its Change Case tool can help you change all uppercase letters to lowercase in cells directly.

Kutools for Excel : with more than 120 handy Excel add-ins, free to try with no limitation in 60 days. 

After installing Kutools for Excel, please do as below:

1. Select the range that you want to change.

2. Click Kutools > Text > Change Case. See screenshot:

doc convert uppercase to lowercase 3

3. In Change Case dialog box, check the lower case option, and then click the OK button. The uppercase cells have been converted to lowercase cells, see screenshot:

doc convert uppercase to lowercase 4

Notes:

1. If you want to change the text strings to proper case which means to capitalize first letter of each word, please select Proper Case in the Change Case dialog box, see screeenshot:

doc convert uppercase to lowercase 5

2. If you want to change the text strings to sentence case which means to capitalize only first letter of your text string, please select Sentence case option in the Change Case dialog box, see screenshot:

doc convert uppercase to lowercase 6

Click to Download Kutools for Excel and free trial Now!

Kutools for Excel 's Change Case tool can quickly change text case to UPPER, LOWER, PROPER, Sentence Case, and tOGGLE cASE. Click to know more…

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

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 · 1 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 · 2 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 · 2 years ago
    advance excel note book .

    warms regard.

    sandeep verma

    Thank's