Excel LOWER Function
LOWER converts every letter in a text value to lowercase.
Use it to normalize emails, labels, IDs, imported names, or lookup keys before comparing or joining text.
1
Choose text
Use typed text, a cell, or a formula
2
Return lowercase text
Letters change; numbers and punctuation stay
LOWER syntax & arguments
Syntax
=LOWER(text)
Required
Optional
-
1
text
RequiredThe text value, cell reference, or formula result to convert to lowercase.
Example
=LOWER(A2)
Convert the text in A2 to lowercase.
LOWER caveats
-
Only letters change
Numbers, punctuation, spaces, and symbols remain in the same positions.
-
It does not clean spacing
LOWER keeps leading, trailing, and repeated spaces. Use TRIM when spacing should be cleaned too.
Need a different case? Use UPPER for uppercase text or PROPER for title case.
Intro LOWER practice problem
Solve the intro problem directly here, or open it on its own page.
Advanced LOWER practice problems
Use LOWER alongside other Excel functions in realistic, less-prescriptive challenges.
