LOWER Formula Generator (2026) — Convert Text to Lowercase | Free Excel & Sheets

Converts all uppercase letters in a text string to lowercase.

Generated Formula
=LOWER(text)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Common Errors & Fixes

  • Text not changing to lowercase

    Causes:
    • The cell contains only numbers or symbols.
    • Text is already lowercase so no change is visible.
    Fixes:
    • Verify the cell actually contains uppercase letters.
    • Test with a known mixed-case value like "Test123".

Frequently Asked Questions

Does LOWER affect numbers?

No, LOWER only affects letter characters. Numbers and special characters remain unchanged.

LOWER vs UPPER vs PROPER — when to use each?

Use LOWER to standardize text to lowercase, UPPER for all caps headings, and PROPER for names and titles.

Does LOWER work in Google Sheets?

Yes, LOWER works identically in Google Sheets with the same syntax.

Related Formulas

CONCATENATETRIMUPPERPROPERLEFT

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More