LOWER Function in Excel
Beginner
Converts all letters in a text string to lowercase.
Syntax
=LOWER(text)Example
Use Case
Convert email addresses to lowercase for consistency.
Common Errors to Avoid
- Doesn't affect numbers, spaces, or punctuation
- Creates formula result, not in-place modification
- Case-insensitive comparisons don't need LOWER - Excel compares case-insensitively by default
Pro Tips
Perfect for normalizing email addresses and usernames. Combine with TRIM for data cleaning. Remember Excel's native text comparison is already case-insensitive unless using EXACT function.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →