LOWER Function
Makes every letter lowercase.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| text | The text or cell reference to convert; can be a literal string in quotes or a cell. | Required |
Basic Example
Lowercase a word
=LOWER("HELLO")All uppercase letters are converted to lowercase.
Advanced Examples
Example 1: Normalize an email prefix
Cell A1 contains "[email protected]"Standardize to lowercase
=LOWER(A1)Example 2: Combine with other text
Build a lowercase key from a cellLowercase within a concatenation
=LOWER("key-" & A1)How LOWER Works
LOWER scans each character of the input; uppercase letters are mapped to their lowercase equivalents while every other character (digits, punctuation, spaces) passes through unchanged.
Important Notes & Limitations
Does not change non-letter characters.
Case conversion follows the system's locale rules and may not cover every Unicode casing edge case.
Only affects a single text value; use with arrays or helper columns for ranges.
Common Errors & Fixes
#VALUE! errorPassing a non-text argument in strict contexts.Fix: Ensure the argument is text or wrap it with TEXT().
Download Practice File
LOWER
lowerPractice LOWER with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the LOWER function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps