How to Convert a Capital Letter to a Lowercase Letter in Excel

Change capital letters to lowercase in Excel with this easy guide

Written by Rain Kengly

Last Updated: May 30, 2025 Fact Checked

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

Download Article

1
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/.
2
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
3
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.
4
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.
5
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.
On Mac, this will be CMD + C.
In this example, this would be A2. You'll need to paste the converted values to the column.
8
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.
9
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.