The fastest way to change capital letters to lowercase

Excel has a built-in function called LOWER() that converts any text to lowercase in seconds. You type the function into a new column, it processes all your text at once, and then you copy the results back over your original data if you want to replace it.

The function works the same way in Excel for Windows, Excel for Mac, and Google Sheets. It handles mixed case (like "HeLLo WoRLD"), all capitals, and text that is already lowercase — it leaves lowercase text unchanged.

If you have a small amount of text, you can also use Find & Replace with regular expressions, but LOWER() is faster and more reliable for most situations.

Key Takeaways

  • The LOWER() function converts text to lowercase and works on entire columns at once without changing your original data until you copy the results back.
  • You type =LOWER(A1) in a new column, press Enter, then drag the formula down to apply it to all rows with text.
  • After the formula produces lowercase text, you copy those results and paste them as values only to replace your original uppercase text.
  • Find & Replace with regular expressions can also convert text but requires more steps and works best on smaller datasets.

Using the LOWER() function step by step

Start by opening your spreadsheet and locating the column with uppercase text you want to convert. Click on an empty column next to it — this is where your lowercase version will appear.

Click on the first cell in that empty column and type =LOWER(A1), replacing A1 with the cell reference of your first uppercase text. Press Enter. Excel will immediately show the lowercase version of that text in the new cell.

Now click back on the cell with your formula. You will see a small square in the bottom right corner of the cell. Click and drag that square down to the last row that contains text. Excel will copy the formula down and convert all your text to lowercase at once.

Once all your text is converted, select the entire column of lowercase results. Copy it (Ctrl+C on Windows, Command+C on Mac). Then click on your original uppercase column and use Paste Special — right-click and choose "Paste Special," then select "Values only." This replaces your original uppercase text with the lowercase version. You can now delete the helper column.

What LOWER() does and does not change

The LOWER() function converts every uppercase letter to its lowercase equivalent. It leaves numbers, spaces, punctuation, and special characters exactly as they are. If your text contains a mix of uppercase and lowercase letters, it converts only the uppercase ones.

The function does not remove extra spaces, fix spelling, or change the order of words. It only handles the case of letters. If you have text like "JOHN SMITH" it becomes "john smith" — nothing more, nothing less.

One important detail: LOWER() does not change your original data. It creates a new version in a different cell. This means you can see both versions side by side and decide whether to keep the change before you overwrite your original text.

Using Find & Replace for smaller amounts of text

If you have only a few cells with uppercase text, Find & Replace can work, but it requires more setup. Open Find & Replace (Ctrl+H on Windows, Command+H on Mac). At the bottom of the dialog, look for "Other options" or "Format" and enable "Regular expressions."

In the Find field, type ^(.*)$. In the Replace field, type $1 but do not press Replace yet. Instead, click the small arrow or button next to the Replace field to access formatting options, then set the replacement text to lowercase. This tells Excel to find all text and replace it with the same text in lowercase format.

This method works but is slower than LOWER() if you have many rows, and it overwrites your original data immediately without a chance to review. For that reason, LOWER() is the safer choice for most situations.

Handling mixed data types and special cases

If your column contains both text and numbers, LOWER() handles it without problems — numbers stay as numbers, text becomes lowercase. If you have formulas in your cells rather than plain text, LOWER() will convert the result of the formula, not the formula itself.

If your text includes accented characters like é, à, or ñ, LOWER() converts those to their lowercase accented versions correctly. The function respects language-specific rules, so it works properly in different languages.

If you have leading or trailing spaces in your text (spaces before or after the actual words), LOWER() preserves them. If you want to remove those spaces at the same time, use =TRIM(LOWER(A1)) instead, which removes extra spaces and converts to lowercase in one step.

Copying results back to your original column

After your LOWER() formula has converted all the text, you need to decide whether to keep the original uppercase version or replace it. If you want to replace it, select all the cells with your lowercase results and copy them.

Click on the first cell of your original uppercase column. Right-click and choose "Paste Special." A dialog will open — make sure "Values" is selected (not "Formulas"). Click OK. This pastes only the text, not the formula, so your original column now contains lowercase text instead of uppercase.

Once you have pasted the values back, you can delete the helper column with the formulas. Your original column now holds the lowercase version, and you have not lost any data in the process.

If you want to keep both versions — the original uppercase and a new lowercase copy — just leave the helper column in place and rename it so you remember what it contains.

Frequently Asked Questions

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

Not directly with LOWER() — the function always creates a result in a new cell. However, you can use that new column as a helper, then copy the results back as values to replace your original text, which is what most people do. Find & Replace can overwrite in place, but it is slower and riskier because you cannot undo as easily.

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

Select only the cells you want to convert and apply LOWER() to just those rows. You can drag the formula down only as far as you need, or type the formula into individual cells one at a time. The process is the same — only the number of cells changes.

Does LOWER() work in Google Sheets the same way as Excel?

Yes, the LOWER() function works identically in Google Sheets. You type the same formula, drag it down the same way, and copy results back the same way. The only difference is the keyboard shortcut for copy and paste might vary slightly depending on your device.

Can I undo the conversion if I change my mind?

If you have not yet saved the file, use Ctrl+Z (Windows) or Command+Z (Mac) to undo. If you saved after converting, you cannot undo. This is why using a helper column first is safer — you can see the results before you overwrite your original text.

What if my text has a mix of uppercase and lowercase that I want to keep?

LOWER() will convert all uppercase letters to lowercase, so you will lose the original mixed case. If you need to preserve the original version, save a copy of your file first, or keep the original column and create the lowercase version in a new column without deleting the original.