How to Change Uppercase to Lowercase in Excel

The fastest way to convert text case in Excel

Excel does not have a built-in button to flip text between uppercase and lowercase. Instead, you use a function called LOWER() to convert uppercase text to lowercase. The function works in any version of Excel — desktop, online, or Mac — and takes about 30 seconds to set up once you know where to put it.

The basic method is to write a formula in a new column, copy it down to match your data, then paste the results back as plain text over your original column. This guide walks you through each step so you do not lose your original data by accident.

Key Takeaways

The LOWER() function converts any text to lowercase: type =LOWER(A1) in a new column and it will convert the text in cell A1.
You must copy the formula results and paste them as values only, otherwise the original uppercase text will reappear if you delete the formula column.
The PROPER() function capitalizes the first letter of each word, and UPPER() converts text to all capitals — both work the same way as LOWER().
If you have thousands of rows, filtering to show only the cells you want to convert saves time and reduces the chance of changing text you meant to keep.

Using the LOWER function to convert text

Open your spreadsheet and locate the column with uppercase text you want to convert. Click on the first empty column to the right of your data — this is where your formula will go. Click on the first cell in that column (for example, if your data is in column A, click cell B1).

Type this formula exactly: =LOWER(A1) — but replace A1 with the cell reference of the first uppercase text you want to convert. Press Enter. Excel will instantly show the lowercase version of that text in cell B1, and the original uppercase text stays in A1 unchanged.

Now you need to copy this formula down to every row that has data. Click on cell B1 again to select it. Look at the bottom right corner of the cell — you will see a small square. Click and drag that square down to the last row with data. Excel will copy the formula down and convert all the text at once. If you have 500 rows, drag all the way to row 500.

Replacing the original text with the converted version

At this point you have two columns: the original uppercase text in column A and the lowercase version in column B. You need to replace column A with the lowercase text, then delete column B. If you just delete column B now, you will lose the lowercase text because the formulas will break.

Click on the column B header to select the entire column of lowercase text. Right-click and choose Copy. Now click on cell A1 (the first cell of your original uppercase data). Right-click and look for Paste Special — click it. A dialog box will open. Look for the option that says Values or Values only, click it, then click OK. This pastes only the text itself, not the formula.

Now column A contains the lowercase text as plain text, not a formula. You can safely delete column B by right-clicking the column header and choosing Delete. Your data is now converted and your spreadsheet is back to its original shape.

Converting to title case or all capitals

Excel has two other text case functions that work exactly the same way as LOWER(). The PROPER() function capitalizes the first letter of each word and makes the rest lowercase — useful for names or titles. The UPPER() function converts everything to capitals.

Use them the same way: type =PROPER(A1) or =UPPER(A1) in a new column, copy the formula down, then copy and paste the results as values back into your original column. The steps are identical to the LOWER() method.

Handling mixed data or partial conversions

If your column contains both uppercase and lowercase text mixed together, LOWER() will convert all of it to lowercase — including text that was already lowercase. This is usually fine, but if you only want to convert certain cells, you can select just those cells before copying the formula down.

Click on the first cell you want to convert, hold Shift, and click on the last cell you want to convert. This selects a range. Now when you drag the formula down, it will only apply to the cells you selected. You can also use filtering to show only uppercase text, convert it, then unhide the rest of your data.

Why the formula approach instead of find and replace

Excel's Find and Replace tool cannot change text case — it only finds exact matches and replaces them with text you type. There is no option to "replace with lowercase version" because the tool does not understand case conversion. The LOWER() function is the only built-in method that actually does this work.

Some versions of Excel have a Format menu option for text case, but it is not available in all versions and does not work reliably. The formula method works everywhere and gives you a backup copy of your original data while you work, which is safer.

Avoiding common mistakes

The most common mistake is deleting column B before pasting the results as values into column A. If you do this, the lowercase text disappears because the formulas break. Always paste as values first, then delete the formula column.

Another mistake is forgetting to change the cell reference in your formula. If you type =LOWER(A1) in cell B1 but your data is actually in column C, the formula will not work. Check that the letter in your formula matches the column your data is in. When you drag the formula down, Excel automatically updates the number (A1 becomes A2, A3, etc.), so you only need to get the column letter right.

If you have headers in row 1 (like "Name" or "Company"), you can include them in your formula copy — LOWER() will convert "Name" to "name", which is usually not what you want. Either start your formula in row 2 instead of row 1, or manually type the header in the new column before you copy the formula down.

Frequently Asked Questions

Can I convert text case without using a formula?

Not in standard Excel. Some third-party add-ins claim to do this, but they are not part of Excel itself. The LOWER() function is the built-in method that works in every version. It takes less than a minute once you know the steps.

What if I only want to convert the first letter to lowercase?

Excel does not have a function for that specific task. You would need to use a combination of functions like =LOWER(LEFT(A1,1))&MID(A1,2,LEN(A1)), but this is complex. For most situations, LOWER() or PROPER() will do what you need.

Does this work in Excel Online?

Yes. The LOWER(), UPPER(), and PROPER() functions work exactly the same way in Excel Online as they do in the desktop version. The copy and paste steps are also identical.

Can I undo the conversion if I make a mistake?

If you have not closed the file, press Ctrl+Z (or Cmd+Z on Mac) to undo. If you closed the file, the original uppercase text is gone unless you saved a backup. Always save a copy of your spreadsheet before converting text case.

What if my text has numbers or special characters?

LOWER() only affects letters. Numbers, spaces, punctuation, and special characters stay exactly the same. So "ABC-123" becomes "abc-123" — only the letters change.

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.