The fastest way to convert uppercase to lowercase in Excel

Excel does not have a built-in button to flip text case, but the LOWER function converts any uppercase or mixed-case text to lowercase in seconds. You type a formula in a new column, copy it down, then paste the results back as values over your original data.

The process takes about two minutes for a column of any size. You do not need to install anything or use a macro — the function is built into every version of Excel.

Key Takeaways

  • The LOWER function converts text to lowercase: type =LOWER(A1) in a cell next to your data, where A1 is the cell containing the text you want to change.
  • Copy the formula down the entire column by selecting the cell with the formula and dragging the small square at the bottom-right corner down to the last row of data.
  • Copy the results, then paste them as values only back into your original column to replace the uppercase text permanently.
  • Delete the helper column once you have pasted the lowercase text into your original column.

Step-by-step: Using the LOWER function

Open your spreadsheet and locate the column containing the text you want to convert. In this example, assume your uppercase text is in column A.

Click on cell B1 (the column next to your data). Type the formula =LOWER(A1) and press Enter. The text from A1 will appear in B1 in lowercase.

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 that contains data in column A. Excel will copy the formula down automatically, converting all the text in column A to lowercase in column B.

Once the formula has filled the entire column, select all the cells in column B that now contain lowercase text. Press Ctrl+C (or Cmd+C on Mac) to copy them.

Replacing your original text with the lowercase version

Click on cell A1 to select the first cell in your original column. Right-click and choose Paste Special, or press Ctrl+Shift+V (Cmd+Shift+V on Mac).

A dialog box will open. Look for the option labeled Values and click on it, then click OK. This pastes only the text itself, not the formula, so your original column now contains lowercase text instead of uppercase.

Column B still contains the formulas you used to convert the text. You can delete column B now — select the entire column by clicking the letter B at the top, right-click, and choose Delete.

Using LOWER with other text functions

If you need to convert text that is mixed with numbers or special characters, LOWER still works — it converts only the letters and leaves numbers and symbols unchanged. For example, =LOWER("INVOICE #2024") becomes "invoice #2024".

You can also combine LOWER with other functions. If you want to convert text to lowercase and remove extra spaces at the same time, use =LOWER(TRIM(A1)). The TRIM function removes leading and trailing spaces, and LOWER converts the result to lowercase.

What to do if your data is in multiple columns

If your uppercase text spans several columns, repeat the process for each column separately. Create helper columns next to each one, use LOWER for each, then paste the results back.

Alternatively, if you have a large amount of data across many columns, you can select all the helper columns at once after filling the formulas down, copy them all together, then paste them as values back into your original columns in one step.

Common mistakes and how to avoid them

The most common error is forgetting to paste as values. If you paste the formula instead of the result, your original column will show the formula text (=LOWER(B1)) instead of the converted text. Always use Paste Special and choose Values to avoid this.

Another mistake is deleting column B before pasting the results back. If you delete the helper column too early, the formulas break and you lose the lowercase text. Always paste the results into your original column first, then delete the helper column.

Frequently Asked Questions

Can I convert text to lowercase without using a formula?

No. Excel has no menu button or direct command to change case. The LOWER function is the standard method. Some third-party add-ins exist, but the built-in function is free and works in every version of Excel.

Will LOWER change numbers or special characters?

No. LOWER converts only letters to lowercase. Numbers, spaces, punctuation, and symbols remain exactly as they are. A cell containing "ITEM #42" becomes "item #42".

What if I want to convert to uppercase or title case instead?

Excel has two other built-in functions: UPPER converts text to all capitals (=UPPER(A1)), and PROPER converts text to title case, where the first letter of each word is capitalized (=PROPER(A1)). Use them the same way as LOWER.

Can I undo the change if I make a mistake?

Yes, if you have not closed the file. Press Ctrl+Z (Cmd+Z on Mac) when ready after pasting to undo the change and restore your original text. If you have already closed the file, you cannot undo — which is why it is wise to save a backup before converting large amounts of text.

Does LOWER work on cells with formulas in them?

LOWER converts the result of a formula to lowercase, not the formula itself. If cell A1 contains a formula that produces "HELLO", then =LOWER(A1) will show "hello". The original formula in A1 remains unchanged.