LOWER function
LOWER converts all letters in a text string to lowercase. It is useful for normalizing emails or keys before matching, and numbers and symbols are untouched.
Example
Read it as a sentence: turn HeLLo into all lowercase letters, which gives hello.
A
B
C
D
1
hello
2
3
Syntax
LOWER(text)
-
text(required) - The text to convert.
Returns: The text in lowercase.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=LOWER("ExCeL") | excel | Mixed case |
=LOWER(123) | 123 | Number |
=LOWER(TRUE) | true | Bool |
=LOWER("ÀÉÎ") | àéî | Accented |
=LOWER(Data!F5) | #DIV/0! | Error |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
Data
Watch out for
- Numbers and symbols are untouched.
Where it works
- Excel
- LOWER is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .