LOWER
Return text with every letter in lower case.
Syntax
LOWER(text)| Argument | Required | Description |
|---|---|---|
text | Required | The text to convert. |
Examples
Every example below was executed against VisiGrid engine 0.35.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=LOWER("ANA BO") | ana bo |
Normalising keys
The usual job is making inconsistent data comparable — email addresses typed with varying capitalisation, imported codes, anything used as a lookup key:
=LOWER(TRIM(A1))Lower-cased and stripped of padding, in that order, is the standard cleanup for a key column. Doing it once in a helper column beats wrapping every formula that touches the data, and it makes the cleaned values visible rather than hidden inside expressions.
Either UPPER or LOWER works for this — what matters is
that both sides get the same treatment.
Excel compatibility
Matches Excel.