The fastest way to change capitals to lowercase

Excel has a built-in function called LOWER that converts any text to lowercase in seconds. You type a formula in a new column, copy it down, then paste the results back as plain text over your original data. This works whether you have 10 cells or 10,000.

The formula is straightforward: =LOWER(A1) where A1 is the cell containing the text you want to convert. If your text is in column A starting at row 1, you type this formula in cell B1, then drag it down to match however many rows you have. Excel automatically adjusts the cell reference for each row.

After the formula runs, you'll have lowercase text in column B while your original capitals remain in column A. You then copy column B, paste it as values into column A to replace the originals, and delete column B. This two-step approach keeps your data safe in case something goes wrong.

Key Takeaways

  • The LOWER function converts text to lowercase: type =LOWER(A1) in a new column and drag down to explore it to all rows at once.
  • After the formula runs, copy the lowercase results, paste them as values over your original text, then delete the formula column.
  • Excel also has UPPER (for all capitals) and PROPER (for title case with the first letter of each word capitalized) if you need other conversions.
  • These functions work on text that's already in cells; they don't change how you type going forward.

Setting up the LOWER formula step by step

Open the spreadsheet with the text you want to convert. Click on the first empty column next to your data — if your capitals are in column A, click on cell B1. Type the formula =LOWER(A1) and press Enter. You'll see the lowercase version of whatever was in A1 appear in B1.

Now you need to copy this formula down to every row that has data. Click on B1 again to select it. Look for the small square in the bottom-right corner of the cell (called the fill handle). Click and drag that square down to the last row with data. As you drag, Excel shows you how many rows you're covering. When you release, the formula copies itself to every cell, automatically changing A1 to A2, A3, and so on.

If you have hundreds of rows, dragging is slow. Instead, click B1, then hold Shift and click on the last cell in column B where you want the formula to go. Then press Ctrl+D (or Cmd+D on Mac). Excel fills the entire range with the formula in one action.

Replacing your original text with the lowercase version

Once the formula has run on all your rows, you have lowercase text in column B and capitals still in column A. You need to copy the lowercase results and paste them back into column A as plain text, not as formulas. If you paste formulas, you'll create a circular reference and Excel will show an error.

Click on the column B header to select the entire column of lowercase text. Press Ctrl+C (or Cmd+C on Mac) to copy. Now click on cell A1 to select where you want to paste. Right-click and choose Paste Special. A dialog box opens. Look for the option that says Values and click it, then click OK. Excel pastes only the text, not the formulas.

Your original capitals in column A are now replaced with lowercase. You can delete column B since you no longer need the formulas. Click on the column B header and press the Delete key, or right-click and choose Delete.

Using PROPER and UPPER for other text cases

Excel's case-conversion functions work the same way. UPPER converts text to all capitals — type =UPPER(A1) if you need that. PROPER capitalizes the first letter of each word and makes the rest lowercase, useful for names and titles — type =PROPER(A1).

All three functions follow the same workflow: create the formula in a new column, drag or fill down to explore it to all rows, copy the results, paste as values over the original, and delete the formula column. The only difference is which function name you use.

What to do if the formula doesn't work

The most common problem is that the cell reference in your formula points to the wrong column. If your text is in column C but you typed =LOWER(A1), the formula will convert whatever is in A1 instead. Check that the letter in your formula matches the column where your text actually is.

Another issue is that the text might not be text at all — it could be formatted as a number or a special data type. The LOWER function still works on these, but sometimes Excel's formatting gets in the way. If the formula returns the text unchanged, try copying the column, pasting it as values first to strip any hidden formatting, then running LOWER on the cleaned data.

If you see #NAME? error in the cell, you've misspelled the function name. Make sure it's LOWER (not LOWE or LOWERCASE) and that you included the equals sign at the start of the formula.

Handling mixed data and special characters

The LOWER function converts only letters. Numbers, spaces, punctuation, and special characters stay exactly as they are. If you have a cell containing "JOHN SMITH 123", LOWER converts it to "john smith 123" — the numbers and space don't change.

This also means the function is safe to use on columns with mixed content. If some cells are empty, LOWER returns an empty cell. If some cells contain formulas that produce text, LOWER converts that text. You can run the function across an entire column without worrying about breaking anything.

Frequently Asked Questions

Can I convert text to lowercase without creating a new column?

Not directly — Excel formulas always need to go somewhere. But you can minimize the extra work by using a helper column in a blank area far to the right, running the formula, then copying and pasting the results back. This keeps your workspace cleaner than using the column when ready next to your data.

What if I only want to convert some cells, not the whole column?

Create the formula only in the cells you need. Instead of dragging down to the last row, drag only to the last cell you want to convert. Then copy and paste as values only for those cells. The rest of your original text stays unchanged.

Does LOWER work on text inside a formula or just plain text?

It works on both. If a cell contains a formula that produces text, LOWER converts that text. For example, =LOWER(CONCATENATE(A1,B1)) would combine two cells and convert the result to lowercase in one step.

Can I undo the conversion if I change my mind?

If you haven't closed the file, press Ctrl+Z (or Cmd+Z on Mac) to undo. Excel will restore your original capitals. If you've already closed and reopened the file, the undo history is gone and you can't recover the original capitals unless you have a backup.

What's the difference between LOWER and PROPER?

LOWER makes everything lowercase. PROPER capitalizes the first letter of each word and lowercases the rest — useful for names like "john smith" becoming "John Smith". UPPER makes everything capitals. Choose based on what format you need.