Syntax
=LOWER(text)
text- The text to convert.
LOWER function in Google Sheets
LOWER converts all letters in text to lowercase. Use it to normalise email addresses, usernames and tags.
Practice LOWER
Task 1 of 2
Normalize the email address in A2 to all lowercase. Answer in B2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
LOWER examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | |
|---|---|---|---|
| 1 | Raw name | SKU | Note |
| 2 | maya PATEL | ELC-0427-NY | Refund requested |
| 3 | leo rossi | FUR-1180-TX | Shipped |
| 4 | AVA KIM | OFC-0093-CA | Refund issued |
| Formula | Result | What it shows |
|---|---|---|
=LOWER(A4) | ava kim | All lowercase. |
=LOWER(B2) | elc-0427-ny | Lowercase SKU. |
=LOWER(TRIM(A2)) | maya patel | Clean and lowercase in one go. |
Tips and common mistakes
- A common pattern for building emails: =LOWER(first & "." & last & "@company.com").
Related functions
Learning step by step? LOWER is covered in Lesson 24: UPPER, LOWER & PROPER of the free course.