How to Change Capital Letters to Lowercase in Excel

The fastest way to convert uppercase text to lowercase in Excel

Excel does not have a built-in button to convert text case, but you can do it in seconds using the LOWER function. This function takes any text — whether it is all capitals, mixed case, or already lowercase — and converts it to lowercase letters.

The process is straightforward: you write a formula in a new column, copy it down to match your data, then paste the results back as plain text if you want to replace the original. Most people finish this task in under a minute once they know the steps.

Key Takeaways

The LOWER function converts any text to lowercase by typing =LOWER(A1) in a cell, where A1 is the cell containing the text you want to change.
You must copy the formula down to every row that contains text, then copy the results and paste them as values to replace the original uppercase text.
If you only need to convert a few cells, you can type the formula once and manually copy each result, but using a helper column is faster for large lists.
Excel also offers UPPER and PROPER functions if you need to convert text to all capitals or to title case instead.

Using the LOWER function to convert text

Start by clicking on an empty column next to your data. If your uppercase text is in column A, click on a cell in column B — any row where your data begins. Type this formula exactly: =LOWER(A1)

Press Enter. The cell will now show the lowercase version of whatever was in A1. If A1 contained "HELLO WORLD", the cell now shows "hello world". The original text in A1 does not change — the formula only displays the lowercase version in the new cell.

Now you need to copy this formula down to every row that has text. Click on the cell with your formula, then look at the small square in the bottom right corner of the cell. Double-click that square, and Excel will automatically copy the formula down to match the length of your data. If that does not work, click and drag that square down to the last row of your data instead.

Replacing the original text with the lowercase version

Once your formula column shows all the lowercase text, you need to copy those results and paste them back into the original column as plain text — not as formulas. If you do not do this step, the lowercase text will disappear if you delete the formula column.

Click on the first cell in your formula column and drag down to select all the cells with lowercase text. Right-click and choose Copy, or press Ctrl+C on Windows or Command+C on Mac.

Now click on the first cell in your original column — the one with the uppercase text. Right-click and look for Paste Special. Click it. A window will open with several options. Make sure Values is selected (it usually is by default), then click OK. The uppercase text is now replaced with lowercase text, and the formulas are gone.

You can now delete the helper column with the formulas. Your original column now contains only lowercase text with no formulas attached.

Converting text in a single cell or a few cells

If you only need to convert one or two cells, you do not need a helper column. Type the formula =LOWER(A1) directly in the cell where you want the lowercase text to appear, press Enter, then copy and paste the result as a value back into the original cell if you want to replace it.

For a handful of cells, this manual approach is actually faster than setting up a full column. For anything more than five or six cells, the helper column method saves time because you only type the formula once and let Excel copy it down automatically.

Using UPPER and PROPER for other text conversions

Excel offers two other text conversion functions if you need different results. The UPPER function works exactly like LOWER but converts text to all capitals — type =UPPER(A1) to convert "hello world" to "HELLO WORLD".

The PROPER function converts text to title case, where the first letter of each word is capitalized and the rest are lowercase. Type =PROPER(A1) to convert "HELLO WORLD" to "Hello World" or "hello world" to "Hello World". This is useful when you have data that is either all capitals or all lowercase and you want it to look like a proper name or heading.

All three functions work the same way: type the formula, copy it down to all rows with data, then paste the results as values to replace the original text if you want to keep the changes.

Troubleshooting common mistakes

If your formula shows an error like #NAME?, you may have typed the formula incorrectly. Check that you wrote =LOWER with no spaces, and that the cell reference (like A1) is correct. The most common mistake is forgetting the equals sign at the start — Excel needs it to recognize the formula.

If the lowercase text appears but your original column still shows uppercase, you did not complete the paste-as-values step. Go back, copy the formula column again, click on the original column, use Paste Special, and make sure Values is selected before clicking OK.

If you accidentally delete the formula column before pasting as values, you can undo the deletion by pressing Ctrl+Z on Windows or Command+Z on Mac. Excel will restore the column, and you can then complete the paste-as-values step.

Working with mixed data types

The LOWER function works on any text, including text mixed with numbers or special characters. If a cell contains "Order #ABC123", the formula =LOWER(A1) will convert it to "order #abc123" — the numbers and symbols stay exactly the same, and only the letters change to lowercase.

If your data contains formulas or links instead of plain text, the LOWER function will still work on the displayed result. However, if you want to preserve the original formulas and only convert the text they display, you should copy the formula results to a new location rather than pasting them back over the original data.

Frequently Asked Questions

Can I convert text to lowercase without using a formula?

Excel does not have a menu button or toolbar option to change text case directly. The LOWER function is the standard method. Some third-party add-ins offer case conversion tools, but the built-in function is free and works in all versions of Excel.

Will the LOWER function change numbers or special characters?

No. The LOWER function only affects letters. Numbers, spaces, punctuation, and symbols remain exactly as they are. A cell containing "ABC-123" becomes "abc-123" — only the letters change.

What happens if I delete the formula column before pasting as values?

The lowercase text disappears because it was only displayed by the formula, not stored as actual text. Press Ctrl+Z or Command+Z immediately to undo the deletion and restore the formula column, then complete the paste-as-values step before deleting again.

Can I convert text case in Excel on a Mac?

Yes. The LOWER, UPPER, and PROPER functions work identically on Mac and Windows versions of Excel. The keyboard shortcuts are slightly different — use Command+C to copy and Command+V to paste on Mac instead of Ctrl+C and Ctrl+V — but the formulas themselves are the same.

How do I convert only part of a cell to lowercase?

You cannot selectively convert part of a cell using the LOWER function — it converts the entire cell contents. If you need to change only certain letters, you would need to use a combination of functions like MID, FIND, and CONCATENATE, which is more complex. For most cases, converting the entire cell and then manually editing any exceptions is faster.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.