The fastest way to convert uppercase text to lowercase

Excel does not have a built-in button to flip text case, but the LOWER function does it in seconds. Type =LOWER(A1) in a blank cell, where A1 is the cell holding the text you want to convert. Press Enter, and the lowercase version appears in your new cell. Copy that formula down to convert an entire column at once.

If you want to replace the original text instead of keeping both versions, copy the lowercase results, paste them as values only back into the original column, then delete the helper column. This method works whether your text is all capitals, mixed case, or already lowercase.

Key Takeaways

  • The LOWER function converts any text to lowercase: type =LOWER(A1) in a blank cell and press Enter.
  • Copy the formula down to convert multiple cells at once, then copy the results and paste as values to replace the original text.
  • Excel also offers UPPER (all capitals) and PROPER (first letter of each word capitalized) functions for other case changes.
  • The LOWER function ignores numbers and punctuation, changing only the letters.

Step-by-step: converting a single cell

Click on an empty cell next to or below the text you want to convert. Type =LOWER(, then click the cell containing your uppercase text, then type ) and press Enter. The lowercase version appears when ready in your new cell.

For example, if the text "HELLO WORLD" is in cell A1, click cell B1, type =LOWER(A1), and press Enter. Cell B1 now shows "hello world". The original cell A1 remains unchanged.

Converting multiple cells at once

Enter the LOWER formula in the first blank cell, as described above. Then click that cell and look for the small square in the bottom right corner. Double-click it, or click and drag it down to copy the formula to as many rows as you need. Excel automatically adjusts the cell reference for each row — the second row becomes =LOWER(A2), the third becomes =LOWER(A3), and so on.

If you have 500 rows of text to convert, this method takes about 10 seconds. The formula applies to every cell in the range you select.

Replacing the original text with the converted version

After running the LOWER formula on all your text, you have two columns: the original uppercase in column A and the lowercase results in column B. To keep only the lowercase version and remove the original, first select all the cells in column B that contain your converted text. Press Ctrl+C (or Cmd+C on Mac) to copy.

Click on the first cell in column A where you want the lowercase text to go. Right-click and choose "Paste Special". A dialog box opens. Click the "Values" option and then click OK. This pastes only the text, not the formula. Now you can delete column B entirely, and column A holds your lowercase text.

Other case-change functions in Excel

Excel provides two other functions for changing text case. UPPER converts text to all capitals — type =UPPER(A1) to turn "hello world" into "HELLO WORLD". PROPER capitalizes the first letter of each word — =PROPER(A1) turns "hello world" into "Hello World".

All three functions work the same way: enter the formula in a blank cell, copy it down for multiple rows, then paste the results as values back into your original column if you want to replace the text. Numbers, spaces, and punctuation are never affected — only letters change.

What to do if your text is in a table or named range

If your data is inside an Excel table (created with Insert > Table), the LOWER formula still works the same way. Create a helper column inside the table, enter the formula, and copy it down. Excel automatically extends the table to include the new column.

If you have named your range of text — for example, calling it "Names" — you can still use LOWER, but you will need to reference individual cells within that range. The formula =LOWER(Names) will not work; instead use =LOWER(INDEX(Names,ROW())) if you are copying the formula down, or reference specific cells like =LOWER(Names[ColumnName]) in a table.

Frequently Asked Questions

Can I undo a case change if I accidentally pasted values over my original text?

Yes, as long as you have not saved the file. Press Ctrl+Z (or Cmd+Z on Mac) to undo the paste operation and restore your original text. If you have already saved, you cannot undo. This is why it is safer to keep the original text in one column and the converted text in another until you are certain you want to replace it.

Does LOWER work with text that has numbers or special characters?

Yes. LOWER changes only the letters and leaves numbers, spaces, punctuation, and symbols exactly as they are. For example, =LOWER("ABC-123") returns "abc-123" with the numbers and hyphen unchanged.

What if I want to change only the first letter of a cell to lowercase?

Use a combination of functions: =LOWER(LEFT(A1,1))&MID(A1,2,LEN(A1)). This takes the first character, converts it to lowercase, and joins it with the rest of the text unchanged. For most cases, LOWER or PROPER is simpler.

Can I use Find and Replace to change case instead of formulas?

Find and Replace in Excel does not have a built-in case-change option. The LOWER function is the standard method. Some third-party add-ins offer case-change buttons, but the formula approach is free and works in every version of Excel.