Excel Lowercase: Convert Text to Lowercase

How-to basics · Updated November 22, 2026

To convert text to lowercase in Excel, use the LOWER function: =LOWER(A1) returns the text in cell A1 with all letters in lowercase. For example, =LOWER("HELLO World") returns hello world.

What the LOWER Function Does

The LOWER function is one of Excel’s text functions. It takes a single argument—the text you want to convert—and returns that text with all uppercase letters changed to lowercase. Numbers, punctuation, and spaces are unaffected. The function works on text strings, cell references, or results of other formulas.

Syntax: =LOWER(text)

Examples:

  • =LOWER("EXCEL") returns excel
  • =LOWER(A2) where A2 contains “Data Entry” returns data entry
  • =LOWER("123 Main St.") returns 123 main st.

Note that LOWER only affects letters. It does not change numbers or symbols, and it does not handle accented characters differently—it converts them according to the Unicode rules (e.g., É becomes é).

How to Use LOWER in a Formula

Using LOWER is straightforward. Here’s a step-by-step:

  1. Click the cell where you want the lowercase result (e.g., B2).
  2. Type =LOWER(.
  3. Click the cell containing the original text (e.g., A2) or type the text in quotes.
  4. Close the parenthesis and press Enter.

For example, with “APPLE” in A2, entering =LOWER(A2) in B2 gives apple. You can then copy the formula down to apply it to a column.

If you want to replace the original data with lowercase text, copy the formula results and use Paste Special > Values to overwrite the originals. Alternatively, use Flash Fill (see below) for a quick no-formula method.

Flash Fill: A No-Formula Alternative

Flash Fill (available in Excel 2013 and later) can convert text without formulas. It’s ideal when you want to keep the original data and just type the expected result once.

  1. In a new column next to your data, type the lowercase version of the first cell manually (e.g., type apple next to APPLE).
  2. Select the cell with your typed value and press Ctrl+E (Windows) or Cmd+E (Mac). Excel will fill the rest of the column with lowercase versions.

If Flash Fill doesn’t automatically recognize the pattern, you can also trigger it from the Data tab: Data > Flash Fill. On Mac, the shortcut is Command+E.

Flash Fill is a one-time conversion—it doesn’t update if the source changes. Use it when you need a static result.

Comparing LOWER, UPPER, and PROPER

Excel offers three case-conversion functions:

  • LOWER – converts all letters to lowercase: =LOWER("HELLO") → hello
  • UPPER – converts all letters to uppercase: =UPPER("hello") → HELLO
  • PROPER – capitalizes the first letter of each word and lowercases the rest: =PROPER("hELLO wORLD") → Hello World

Choose LOWER when you need uniform lowercase for data consistency, such as email addresses or usernames. Use UPPER for acronyms or emphasis. Use PROPER for names or titles.

Common Problems and Misconceptions

Problem: LOWER doesn’t change numbers or symbols. That’s expected—it only affects letters. If you need to remove spaces or other characters, combine with functions like TRIM or SUBSTITUTE.

Misconception: LOWER changes the original cell. It doesn’t. It returns a new value. The original cell remains unchanged unless you overwrite it.

Problem: Non-English characters. LOWER works with accented characters (e.g., Ä → ä) because it uses Unicode rules. However, it does not handle language-specific case rules (like the German ß, which sometimes converts to SS in uppercase, but LOWER leaves it as ß).

Problem: Flash Fill not working. Ensure the pattern is clear and that there are no blank rows. Also, Flash Fill might not work if the data is in an Excel Table—try converting to a range first.

Using LOWER with Other Functions

You can nest LOWER inside other formulas to clean data. For example, to compare text case-insensitively:

With names in A2:A20 and lookup value in B1, use:

=IF(LOWER(A2)=LOWER($B$1),"Match","No match")

This returns “Match” if the text matches regardless of case. Another common use is to normalize email addresses before sending mail merges: =LOWER(TRIM(A2)) removes extra spaces and lowercases.

Alternatives: Power Query and VBA

For large datasets or repeated conversions, consider Power Query (Get & Transform):

  1. Select your data and go to Data > From Table/Range.
  2. In the Power Query editor, select the column(s), then go to Transform > Format > Lowercase.
  3. Click Close & Load to return the results to Excel.

This method is non-destructive and refreshes if your source changes.

If you prefer VBA, a simple macro can convert a selected range. Here’s an example:

Sub ConvertToLowercase()
    Dim cell As Range
    For Each cell In Selection
        If cell.HasFormula = False Then
            cell.Value = LCase(cell.Value)
        End If
    Next cell
End Sub

Before running any macro, save a copy of your workbook, because macros cannot be undone with Ctrl+Z.

Frequently Asked Questions

How do I make all text lowercase in Excel without formulas? Use Flash Fill: type the lowercase version in the first cell, then press Ctrl+E (Cmd+E on Mac). Or use Power Query as described above.

Does LOWER work on numbers? No, it only affects letters. Numbers remain unchanged.

Can I convert a whole column to lowercase at once? Yes. Enter the formula in the first row, then double-click the fill handle (the small square at the bottom-right of the cell) to copy down. Or use Power Query to transform the entire column.

Why is my LOWER formula showing an error? Check that you have the correct number of arguments and that the text is in quotes if typed directly. Also ensure you don’t have extra spaces or non-printable characters—use TRIM and CLEAN to remove them.

What’s the difference between LOWER and lowercase in Flash Fill? LOWER is a dynamic formula that updates when the source changes. Flash Fill is static—it doesn’t update. Choose based on whether you need live updates.

Does LOWER work in Excel for the web? Yes, LOWER is available in Excel for the web, and the syntax is the same.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.