Converting Text From Uppercase to Lowercase in Excel

The fastest way to change uppercase text to lowercase

Excel does not have a built-in button to convert text case, but the LOWER function does this in seconds. If you have uppercase text in column A, click on an empty column (say, column B), type =LOWER(A1) in the first cell, and press Enter. Excel converts that cell's text to lowercase. Then copy that formula down to every row that has text, and you have all your lowercase versions in column B.

Once the conversion is done, copy column B, right-click on column A, choose Paste Special, click Values, and click OK. This replaces your original uppercase text with the lowercase versions. Delete column B after that, and you are finished.

If you only need to convert a few cells, the LOWER function alone is enough — you do not have to replace the original text. But if you want the result to replace what you started with, the Paste Special step is what makes that happen.

Key Takeaways

The LOWER function converts any text to lowercase: type =LOWER(A1) in an empty cell next to your uppercase text.
Copy the formula down to every row with text by selecting the cell and dragging the small square at its bottom-right corner down to the last row.
To replace the original uppercase text, copy the lowercase results, then use Paste Special > Values to overwrite the original column.
Excel also has UPPER (converts to all capitals) and PROPER (capitalizes the first letter of each word) if you need other text formats.

Step-by-step: Converting a full column of uppercase text

Open your spreadsheet and locate the column with uppercase text. Click on the first empty cell in the column next to it — if your uppercase text is in column A, click cell B1. Type the formula =LOWER(A1) and press Enter. You will see the text from A1 appear in B1, but in lowercase.

Now you need to copy this formula down to every row that has text. Click on cell B1 again. Look at the bottom-right corner of the cell — you will see a tiny square. Click and hold that square, then drag it down to the last row with text. As you drag, Excel shows you how many rows you are filling. Release the mouse button when you reach the end. Every cell in column B now shows the lowercase version of the text in column A.

Select the entire column B by clicking the column header. Press Ctrl+C (or Cmd+C on Mac) to copy. Click on the column header for column A to select it. Right-click and choose Paste Special. A dialog box opens. Click the Values option and then click OK. Column A now contains the lowercase text, and column B can be deleted.

Converting only certain cells without replacing the original

If you want to keep your original uppercase text and just have lowercase versions somewhere else, you do not need to use Paste Special. straightforward use the LOWER function in an empty area of your spreadsheet and leave it there. The formula stays active, so if you change the original text, the lowercase version updates automatically.

This is useful if you are comparing data or creating a version of your list for a different purpose. You can also copy just the results from the LOWER formula (without using Paste Special) if you want to move them to a different sheet or file later.

Using UPPER and PROPER for other text conversions

Excel has two other text-case functions that work exactly like LOWER. The UPPER function converts text to all capitals — type =UPPER(A1) to convert lowercase or mixed-case text to uppercase. The PROPER function capitalizes the first letter of each word — type =PROPER(A1) to convert "JOHN SMITH" to "John Smith" or "john smith" to "John Smith".

All three functions work the same way: put the formula in an empty cell, copy it down to every row you need, and use Paste Special > Values if you want to replace the original text. You can also combine them — for example, =PROPER(LOWER(A1)) converts text to lowercase first, then capitalizes the first letter of each word, which is useful for cleaning up messy data.

What to do if the formula does not work

The most common mistake is typing the formula in the same column as your original text, which overwrites it. Always use an empty column first. If you see #NAME? as the result, you may have misspelled the function name — check that you typed LOWER, UPPER, or PROPER correctly, with no extra spaces.

If the text does not change at all, make sure you are referencing the correct cell. The formula =LOWER(A1) only works if the text you want to convert is actually in cell A1. Click on the cell with the text you want to convert, and note its column letter and row number, then use that in your formula.

Converting text in a different sheet or file

If your uppercase text is in a different sheet within the same file, the formula still works — just include the sheet name. For example, =LOWER(Sheet2.A1) converts the text in cell A1 of Sheet2 to lowercase in your current sheet. If you are working with a file from another workbook, you can open both files, then use =LOWER([OtherFile.xlsx]Sheet1.A1), though the exact format depends on your version of Excel.

For most situations, copying the text into your current sheet first is simpler than using cross-file formulas. But if you need to keep the files separate, the formula approach works and updates automatically if the original text changes.

Frequently Asked Questions

Can I convert text case without using a formula?

Excel does not have a menu option or button for text case conversion. The LOWER, UPPER, and PROPER functions are the built-in way to do it. Some third-party add-ins offer case conversion tools, but the formula method is free and works in every version of Excel.

What happens if I copy the LOWER formula to a cell with no text?

The formula returns an empty result, which looks like a blank cell. This is harmless — you can leave it there or delete it. If you later add text to that original cell, the formula will convert it automatically.

Can I undo the conversion if I change my mind?

If you used Paste Special to replace the original text, pressing Ctrl+Z (or Cmd+Z on Mac) when ready after will undo it. If you closed the file and reopened it, the original uppercase text is gone — keep a backup copy of important data before converting.

Does the LOWER function work with numbers or special characters?

LOWER only affects letters. Numbers, spaces, punctuation, and symbols stay exactly the same. If a cell contains "JOHN123", LOWER converts it to "john123" — the numbers do not change.

How do I convert text case in Google Sheets?

Google Sheets uses the same LOWER, UPPER, and PROPER functions as Excel, and the steps are identical. The main difference is that Google Sheets does not have a Paste Special dialog — instead, you paste normally, then right-click and choose "Paste special" > "Values only".

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.