LOWER
Makes all letters in text lowercase: brings email addresses, usernames and tags to one look.
LOWER(text)- text
- The cell or text to convert to lowercase.
Return value
The same text in lowercase letters.
Examples
Customer emails
fx
A
B
C
1
2
3
4
5
6
7
Email from form
Email
John.Smith@Gmail.com
EMILY.DAVIS@YAHOO.COM
Mike_B@Outlook.com
s.johnson@aol.com
Sheet1
Details
LOWER changes all uppercase letters to lowercase. Digits, spaces and symbols stay as they were.
It's usually applied to data where case means nothing but gets in the way of reading: email addresses, usernames, hashtags.
Common mistakes
- LOWER spoils names and abbreviations: "IBM Corp" turns into "ibm corp". For names, use PROPER.
- Extra spaces stay. If you need both, wrap the result in TRIM.