UPPER and LOWER Function Generator
UPPER converts text to uppercase; LOWER converts to lowercase. Useful for normalizing data before comparison or display.
Syntax
=UPPER(text) or =LOWER(text)Try it — generate a UPPER / LOWER formula
Examples
Normalize emails
=LOWER(A2)All lowercase — prevents case-based duplicate rows.
Country codes uppercase
=UPPER(A2)US, UK, FR, etc.
Compare ignoring case
=LOWER(A2)=LOWER(B2)Excel comparison is case-insensitive but being explicit avoids surprises.
Tips
- ✓Pair with TRIM to fully normalize input.
- ✓Use PROPER for title case.
- ✓Excel cell comparison is case-insensitive by default but EXACT() is case-sensitive.
Related Formulas
PROPER
PROPER converts text to title case — first letter of each word capitalized, the ...
TRIM
TRIM removes leading and trailing spaces and collapses multiple internal spaces ...
SUBSTITUTE
SUBSTITUTE replaces occurrences of a specific text inside a string. Lets you tar...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free