The fastest way to change text to lowercase in Excel

Excel does not have a built-in button to convert text to lowercase. Instead, you use a function called LOWER, which takes the text you point it to and converts every letter to lowercase. You type the function into a new column, copy it down for all your rows, then paste the results back as plain text if you want to replace the original column.

The whole process takes about two minutes once you know the steps. You do not need to install anything or change any settings — the LOWER function is built into every version of Excel.

Key Takeaways

  • The LOWER function converts text to lowercase: type =LOWER(A1) in a cell to convert the text in cell A1.
  • You copy the formula down the entire column, then paste the results as values to replace the original text.
  • If you only need lowercase text once, you can leave the formula in place instead of converting to plain text.
  • LOWER works on any text in any column — just change the cell reference (A1, B2, C5) to match where your text is.
  • The function ignores numbers and special characters, converting only the letters.

Setting up the LOWER function in a new column

Start by clicking on an empty column next to your text. If your original text is in column A, click on a cell in column B — it does not matter which row, but starting at the top makes it easier to see what you are doing. Let's say your text starts in cell A1 and you click on cell B1.

Type this exactly: =LOWER(A1) and press Enter. Excel will when ready show you the text from A1 converted to lowercase. If A1 contained "HELLO WORLD", B1 now shows "hello world". If A1 contained "John Smith", B1 shows "john smith".

Now you need to copy this formula down to every row that has text. Click back on B1 (the cell with your formula), then look at the small square in the bottom right corner of the cell. Click and drag that square down to the last row of your data. Excel will copy the formula down and adjust the cell reference automatically — B2 will contain =LOWER(A2), B3 will contain =LOWER(A3), and so on.

Replacing your original text with the lowercase version

Once the formula is copied down the entire column, you have two choices: keep the formula in place, or replace your original text with the lowercase version. Most people want to replace the original, so here is how.

Click on the column header B (the entire column with your lowercase results) to select it. Then right-click and choose Copy. Now click on the column header A (your original text) and right-click. Look for Paste Special — this is the key step. Click it.

A dialog box will open with several options. Look for Values and click on it, then click OK. Excel will paste only the text (not the formula) into column A, replacing your original uppercase or mixed-case text. You can now delete column B since you no longer need it.

What to do if you have text in multiple columns

If your text is spread across several columns — for example, first names in column A and last names in column B — you need to run the LOWER function on each column separately. Click on an empty column (like column C), type =LOWER(A1), and copy it down. Then in another empty column (like column D), type =LOWER(B1) and copy that down too.

Once both columns of formulas are done, select both columns C and D together, copy them, then use Paste Special to paste them as values into columns A and B. This replaces both columns at once. Delete columns C and D when you are finished.

When to use LOWER instead of other methods

The LOWER function is the right choice when you have a list of text and need all of it converted at once. It works on any length of text — a single word, a full sentence, or a paragraph. It also works on text mixed with numbers: if a cell contains "Order123ABC", LOWER converts it to "order123abc", leaving the numbers untouched.

If you only need to change one or two cells, you can also just retype them in lowercase by hand. But if you have dozens or hundreds of entries, the LOWER function saves you hours of work and eliminates the chance of typos.

Other text conversion functions that work the same way

Excel has two related functions you might find useful. UPPER converts text to all uppercase — type =UPPER(A1) the same way you would use LOWER. PROPER converts text to title case, where the first letter of each word is uppercase and the rest are lowercase — so "john smith" becomes "John Smith".

All three functions work identically: you type the function in a new column, copy it down, then paste the results as values to replace the original text. The only difference is which function name you use.

Troubleshooting common problems

If your formula shows an error like #NAME?, you may have typed the function name wrong. Check that you typed =LOWER (not =lower or =Lowercase) and that you included the parentheses and cell reference. Excel is not case-sensitive for function names, but the syntax must be exact.

If the lowercase text appears but looks the same as the original, your original text may already be lowercase, or it may be formatted in a way that makes it look uppercase on screen. The LOWER function will still work correctly — the text itself is lowercase even if the formatting makes it appear otherwise.

If you copy the formula down and some cells stay blank, check that those rows actually contain text. If a cell in column A is empty, the formula in column B will also be empty. This is normal and not an error.

Frequently Asked Questions

Can I undo this if I change my mind?

Yes, as long as you have not closed the file. Press Ctrl+Z (or Cmd+Z on Mac) to undo the last action. You can undo multiple times to go back several steps. Once you close and reopen the file, you cannot undo anymore, so make sure the lowercase text is what you want before you save.

What if I want to keep both the original text and the lowercase version?

Do not use Paste Special to replace the original column. Instead, just leave the formula results in the new column. You now have your original text in column A and the lowercase version in column B. Both stay in your spreadsheet.

Does LOWER work on text with accents or special characters?

Yes. LOWER converts accented letters like É to é, and Ñ to ñ. Special characters like hyphens, apostrophes, and punctuation are not affected — they stay exactly as they are.

Can I convert text to lowercase without using a formula?

Not directly in Excel. The LOWER function is the standard method. Some versions of Excel have a Format menu option, but it only changes how the text appears on screen, not the actual text itself — if you copy it elsewhere, it reverts to the original case.

What if my text is in a different language?

LOWER works on most languages that use an alphabet, including Spanish, French, German, and Russian. It converts accented characters correctly. If you are working in a language that does not use uppercase and lowercase (like Chinese or Arabic), LOWER will not change anything, which is the correct behavior.