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

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

For example, you have the following uppercase text strings, how could you quickly and easily change the uppercase letters to lowercase letters?

doc-change-uppercase-to-lowercase1


Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

arrow blue right bubbleChange 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.

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

doc-change-uppercase-to-lowercase2

Step 2: Press Enter key and the formula has been applied to the cell B1, then select cell B1, 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-change-uppercase-to-lowercase3

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.


arrow blue right bubbleChange 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 includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

Step1: Select the range that you want to change.

Step2: Click Kutools > Text Tools > Change Case. See screenshot:

doc-change-uppercase-to-lowercase4

Step 3: In Change Case dialog box, check the lower case option.

doc-change-uppercase-to-lowercase5

Step4: then click OK or Apply. The selected uppercase letters have been converted to lowercase letters in the original range.

doc-change-uppercase-to-lowercase6

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

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Comments  

+5#Lisa B2014-01-09 16:56
Or, use function =Proper(cell) to have capitals for first letter of names, cities, etc...
Reply | Reply with quote | Quote
+1#Bryan2014-04-08 21:13
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.
Reply | Reply with quote | Quote
-1#asad2014-03-01 14:58
Thanks. Great article. MS should use this on their documentation instead
Reply | Reply with quote | Quote
0#Nas2014-04-23 04:55
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.


--------------------------------------------------------------------------------
Reply | Reply with quote | Quote
-1#John Smith2014-05-08 13:09
Thanks a lot. you have done a great job. :-):-):-) this is an great article
Reply | Reply with quote | Quote
0#Madhuri2014-06-03 10:06
how to small letters change to capital letter in key board excel 2007
Reply | Reply with quote | Quote
0#Basha2014-07-17 18:56
Very Helpful.

Thank You
Reply | Reply with quote | Quote

Add comment


Security code
Refresh