Text
LOWER
Definition
LOWER returns a text string converted to lowercase letters.
Syntax
=LOWER(text)
Arguments
| Argument | Meaning |
|---|---|
text |
The text, or the cell holding it, to convert. |
Worked example
A dock sheet stores status words in mixed case. The words are in B2:B4.
| A: Bay | B: Status |
|---|---|
| 1 | Ready |
| 2 | HOLD |
| 3 | Go |
Formula: =LOWER(B2)
Result: ready. Every letter in Ready is converted to lowercase.
Practice
Cell A2 holds HELLO. In B2, write a formula that returns that word in lowercase.
- In B2, write a LOWER formula for A2.
- B2 should show A2 in lowercase.
Step 1 of 2
Enter =LOWER(A2) in B2.
A2 is HELLO, so lowercase is hello.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses LOWER.
B2 now shows hello.
Related functions
LOWER is the opposite of UPPER, and LEFT can then take a prefix from the converted text.
Common mistake
Comparing LOWER of one cell with mixed-case text that was never converted, so "ready" does not equal Ready and the match fails.