How to Use the LOWER Function in Microsoft Excel

When you copy data from a website, export a list from a messy database, or inherit a spreadsheet from a coworker who loved leaving their Caps Lock key on, you often end up with text that is aggressively capitalized (e.g., “JOHN SMITH” or “APPLE INC”).

Manually retyping hundreds of rows of capitalized text is a massive waste of time. Instead, you can use Microsoft Excel’s built-in LOWER function to instantly convert any text into clean, uniform lowercase letters.

The Syntax of the LOWER Function

The LOWER function is incredibly simple. It only requires one argument: the text (or the cell reference) that you want to convert.

Syntax: =LOWER(text)

How to Convert Text to Lowercase

Imagine you have a list of shouting email addresses in Column A (e.g., Cell A2 contains [email protected]) and you want to fix them.

1. Click on an empty cell next to your data (for example, Cell B2).
2. Type the formula: =LOWER(A2)
3. Press Enter.

Cell B2 will instantly display [email protected]. It takes every single uppercase letter in the original cell and forces it into lowercase.

Numbers, symbols, and punctuation marks (like the @ symbol or periods) are completely ignored and left exactly as they are.

Applying the Formula to the Entire List

Once you have written the formula for the first row, you don’t need to type it again.

1. Click on Cell B2 (the one containing your formula).
2. Look at the bottom-right corner of the cell. You will see a tiny green square called the “Fill Handle.”
3. Hover your mouse over the green square until your cursor turns into a black cross.
4. Double-click the green square.

Excel will automatically copy the LOWER formula down the entire column, instantly converting every single email address in your list into lowercase.

Replacing the Original Data

Right now, your clean lowercase text in Column B relies on a formula. If you delete the messy shouting text in Column A, your new text will break.

To finalize the data:

1. Highlight all the new lowercase text in Column B.
2. Press Ctrl+C (or Cmd+C on a Mac) to copy the cells.
3. Right-click on Cell A2 (the top of your original, messy column).
4. Under “Paste Options,” click the icon with the numbers 123 (Paste Values).

This pastes the clean lowercase text over the old data. You can now safely delete Column B.