LOWER Function in Excel: Convert Text to Small Letters

LOWER Function in Excel: Convert Text to Small Letters featured illustration

📎 This article includes 1 downloadable practice file ↓

⏱ 2 min readUpdated 5 October 2026

TextLevel: BeginnerAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. LOWER in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions
  9. Continue learning

LOWER converts all letters to lowercase — handy when comparing emails or usernames typed inconsistently.

Advertisement

Syntax

=LOWER(text)
Argument What it means
text Text to convert.

Examples

Example 1

=LOWER(A2)=LOWER(B2)

Compare two emails ignoring case (a plain = already ignores case, but this makes intent clear).

LOWER in practice

Where you will use it

  • Standardise emails to lowercase
  • Case-insensitive matching keys
  • Clean imported data

Worked example

TextFormulaResult
[email protected]=LOWER(A2)[email protected]
NORTH=LOWER(A3)north
Sharma Traders=LOWER(A4)sharma traders

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Expecting it to fix spacesCombine with TRIM
Changing codes that must stay uppercaseApply only to columns where case doesn't matter

UPPER · PROPER

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

⚡ Interactive Practice Lab & Formula Tester:

Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.

Continue learning

All Text guides →
REGEXREPLACE Function in Excel: Find and Replace With PatternsREGEXREPLACE replaces text matching a pattern — strip every non-digit, collapse repeated spaces, mask…T Function in Excel: Keep Text, Blank Out NumbersT returns text unchanged and anything else as an empty string. Rarely needed alone,…NUMBERVALUE Function in Excel: Convert Text Numbers With Any SeparatorsNUMBERVALUE converts text to a number using separators you specify — essential for European-style…VALUE Function in Excel: Convert Text to a NumberVALUE turns text that looks like a number into a real number, so SUM…

📎 Practice files for this article

  • 📗
    Practice workbook: Text & cleaning24 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
    ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.

✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong