How to change letter case in ms 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.
Recommended Productivity Tools
For example, you have the following uppercase text strings, how could you quickly and easily change the uppercase letters to lowercase letters?
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!
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.
Step 1: In the adjacent cell B1, enter the formula =LOWER (A1) . See screenshot:
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:
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.
Free Trial 60 days
Step1: Select the range that you want to change.
Step 3: In Change Case dialog box, check the lower case option, and then click the OK button.
Then the selected uppercase letters are converted to lowercase letters in the original range.
Recommended Productivity Tools
Office Tab
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Kutools for Excel
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
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.