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

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



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 > Change Case. See screenshot:

Step 3: In Change Case dialog box, check the lower case option, and then click the OK button.

doc-change-uppercase-to-lowercase5

Then the selected uppercase letters are 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…

 

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

Comments  

Permalink +12 Lisa B
Or, use function =Proper(cell) to have capitals for first letter of names, cities, etc...
2014-01-09 16:56 Reply Reply with quote Quote
Permalink +2 Bryan
This is an even Faster way to do it using VBA instead of excel functions.

Sub LOWER_CASE()
Addr = Intersect(Activ eSheet.UsedRang e, Selection).Addr ess
Range(Addr) = Evaluate("IF(LE N(" & Addr & "),LOWER(" & Addr & "),"""")")
End Sub

Go to developer tab>macros>(typ e 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.
2014-04-08 21:13 Reply Reply with quote Quote
Permalink 0 anna
sometimes using VBA is more confusing than excel function, especially for Excel amateur like me lol
2016-02-03 07:06 Reply Reply with quote Quote
Permalink -2 asad
Thanks. Great article. MS should use this on their documentation instead
2014-03-01 14:58 Reply Reply with quote Quote
Permalink +1 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.


--------------------------------------------------------------------------------
2014-04-23 04:55 Reply Reply with quote Quote
Permalink 0 tester
Quoting 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.


--------------------------------------------------------------------------------

copy ---> paste special ----> values
2014-11-02 09:19 Reply Reply with quote Quote
Permalink -1 John Smith
Thanks a lot. you have done a great job. :-) :-) :-) this is an great article
2014-05-08 13:09 Reply Reply with quote Quote
Permalink +5 Madhuri
how to small letters change to capital letter in key board excel 2007
2014-06-03 10:06 Reply Reply with quote Quote
Permalink -1 Rohit Karle
Just use =Upper(Cell)
2014-08-20 09:21 Reply Reply with quote Quote
Permalink -1 Basha
Very Helpful.

Thank You
2014-07-17 18:56 Reply Reply with quote Quote
Permalink +5 Jeanne B.
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?
2014-08-14 19:06 Reply Reply with quote Quote
Permalink 0 Bjorn
Was really easy. Thanks Jeanne.
2014-10-24 07:11 Reply Reply with quote Quote
Permalink -1 naim
how to set uppercase text with number.
for example : jun-14
2014-09-05 01:06 Reply Reply with quote Quote
Permalink -1 Rohit Karle
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.
2014-09-05 07:04 Reply Reply with quote Quote
Permalink -1 Nandu
Is there a short key for this ??
2014-10-07 12:28 Reply Reply with quote Quote
Permalink -1 Diljith
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
2015-04-24 06:27 Reply Reply with quote Quote
Permalink -1 mckillio
This didn't do anything, my cell (F2) just says =LOWER(E2). Does this have to be columns A and B?
2015-06-01 22:29 Reply Reply with quote Quote
Permalink 0 parvathi arungopal
thanks for your good answer
2015-06-03 10:47 Reply Reply with quote Quote
Permalink -2 KIRAN
IT WAS USEFULTHANK YOU :)
2015-06-03 11:44 Reply Reply with quote Quote
Permalink -1 PHILEMON
THAT FOR MAKING ME UNDERSTAND
2015-06-22 02:26 Reply Reply with quote Quote
Permalink -1 ATULCHANDRA
VERY USEFUL ANSWER WITH MULTIPLE OPTION.
2015-07-02 14:20 Reply Reply with quote Quote
Permalink -1 Rsilva
very useful and easy

thank you
2015-08-07 13:17 Reply Reply with quote Quote
Permalink 0 Ola
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
2015-08-25 08:13 Reply Reply with quote Quote
Permalink 0 Sagar Jadhav
Thank you Very much it's very easy use ....... :-)
2015-08-27 06:07 Reply Reply with quote Quote
Permalink +1 Sasikumar
Dear sir,

when i strat to enter in the excel column i expected only uppercase using some formula. Please answer me
2015-09-05 16:08 Reply Reply with quote Quote
Permalink 0 sharad
thanks,
your suggestion very helpful
2015-09-09 19:56 Reply Reply with quote Quote
Permalink 0 Jessica Vu
Thanks very much. It is so useful & easy to understanding. :-)
2015-09-18 23:52 Reply Reply with quote Quote
Permalink 0 fatima
Thank you so much i learnt what i wanted to know in excel
2016-01-16 06:13 Reply Reply with quote Quote
Permalink 0 sandeep verma
advance excel note book .

warms regard.

sandeep verma

Thank's
2016-03-26 13:09 Reply Reply with quote Quote
Permalink 0 sandeep verma
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.
2016-03-26 13:29 Reply Reply with quote Quote
Permalink 0 Raghavendra
My friends Upper case and Lower case formula is =UPPER(COLOM &ROW ) ENTER
2016-09-18 06:57 Reply Reply with quote Quote
Permalink 0 Prabhukalyan Dhal
Is there any simple method without using any formula within the same excel sheet ?
2017-04-10 10:28 Reply Reply with quote Quote

Add comment


Security code
Refresh