🔤 Text Function · beginner
LOWER Function in Google Sheets
Converts text to lowercase. Used for email normalization and case-insensitive dedup.
Syntax
LOWER(text)Returns: text in lowercase.
Excel equivalent: LOWER (identical)
Parameters
| Name | Required | Description |
|---|---|---|
| text | Required | String to convert. |
Examples
Normalize emails
=LOWER(TRIM(A2))Lowercase + trim for dedup.
Whole column
=ARRAYFORMULA(LOWER(A2:A100))Apply to a column.
When to use an alternative
- UPPER — Uppercase.
- PROPER — Title case.
Common errors and how to fix them
Doesn't fix dupes
Cause: Hidden whitespace.
Fix: Combine LOWER(TRIM(A2)).
Related functions
UPPER
Converts text to uppercase....
TRIM
Removes leading, trailing, and duplicate internal whitespace from a text value. The first cleanup fu...
CONCATENATE
Joins multiple text values into one string. The classic way to combine fields, but TEXTJOIN is usual...
FIND
Returns position of one string in another, case-sensitively....
LEFT
Returns the leftmost N characters of a string. The simplest text-extraction function — useful for pr...
Frequently Asked Questions
Why LOWER + TRIM?
Both case and whitespace are common dedup failures. Important for emails.