Download Article
Change capital letters to lowercase in Excel with this easy guide
Download Article
If you're dealing with Excel data that is in the wrong case, you can convert uppercase letters to lowercase with a simple formula. You'll just need to create a temporary column for the formula and paste the new values where you need them. Here's how to convert a capital letter to a lowercase letter in Microsoft Excel.
Quick Steps
- Insert a temporary column next to the column you want to convert.
- Type =LOWER(cell) in the temporary column.
- Press Enter to complete the formula.
- Select the formula cell and double-click the black square to fill down the column.
- Copy and paste the new values from the temporary column into the original.
Steps
-
Open a workbook in Microsoft Excel . You can use an existing project or create a new spreadsheet . Make sure you're on the correct worksheet.
- Microsoft Excel is available on Windows and Mac . You can also use the online web version at https://www.office.com/ .
-
Insert a new column next to the text you want to convert. This will be a temporary column that holds the formula; it can be deleted afterwards.
- Right-click the column header to the right of where you want to add a new column. Select Insert .
Advertisement -
Type =LOWER(cell) into the empty cell. Replace cell with the first cell number of the column you want to convert. This formula will allow you to convert a cell to lowercase letters. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- For example, to convert cell A2, the formula should look like =LOWER(A2) .
- Alternatively, you can use the =PROPER(cell) formula to convert to the proper case with the initials capitalized, or =UPPER(cell) to convert to uppercase.
-
Press ↵ Enter or â Return on your keyboard. This will process your formula and convert your text in the specified cell to lowercase letters.
- The converted text will show up in your formula cell here.
-
Select the formula cell and double-click the square. This is the small black square at the bottom-right corner of the formula cell.
- This will fill down the formula in the new column and select the new values.
-
Press Ctrl + C to copy the values. On Mac, this will be CMD + C .
-
Right-click the first cell of the column you want to convert. In this example, this would be A2 . You'll need to paste the converted values to the column.
-
Select Values under "Paste Options". This looks like a clipboard with 123 on it.
- On some devices, you may need to click Paste , and then Values .
-
Delete the temporary column. After you paste the new values, you'll no longer need the formulas within the temporary column.
- Right-click the column header and click Delete .
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
References
About This Article
Article Summary
X
1. Open the spreadsheet.
2. Click an empty cell.
3. Type " =LOWER(cell)
" into the cell.
4. Replace " cell
" with the cell number of your text.
5. Press Enter
or Return
to convert.
6. Hold down the dot on the bottom-right of the cell.
7. Drag the cell outline to convert a cell range.
Did this summary help you?
Thanks to all authors for creating a page that has been read 26,091 times.
Advertisement