LOWER returns a copy of text with every uppercase letter turned lowercase. It is the standard way to normalize email addresses, URLs and free-text input where case should not matter. Digits, spaces and punctuation pass through untouched.
Returns text. Only letters change; length, digits and symbols are preserved.
LOWER normalizes emails and codes without touching structure. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =LOWER(A3) | bob jones | Name to lowercase |
| =LOWER(C3) | london | City to lowercase |
| =LOWER(B3) | cd-34 | Code to lowercase |
| =LOWER(A2) | alice smith | Mixed case to lower |
| =LOWER("HELLO WORLD") | hello world | Literal string |
| =LOWER(A5) | david brown | Name normalized |
| =LOWER("Excel 2026") | excel 2026 | Digits unchanged |
| =LOWER(123) | 123 | Number coerced to text |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to lowercase names, emails and codes.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
LOWER is a core text function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
LOWER is one piece. The full course walks the toolkit end to end with live, measured examples.