LOWER
Converts a text string to lowercase.
Syntax:
LOWER(text)
returns text with all characters converted to lower case.
Example:
LOWER("Good MORNING")
returns good morning
Application:
Scenario:
Imagine a company that sells products online. They have a Customers table that stores customer information. Over time, due to different data entry methods, the email column has inconsistent casing. This makes it difficult to search for a specific customer by their email address.
Problem:
A customer, "Jane Doe," reports that she is not receiving her order confirmations. The support team wants to find her record using her email address, jane.doe@email.com. However, the data in the Customers table is not uniform. Some entries are in all caps, some are in title case, and some have mixed casing.
Customers Table:
Customer ID | First Name | Last Name | |||
|---|---|---|---|---|---|
A | B | C | D | ||
1 | 1 | Jane | Doe | JANE.DOE@EMAIL.COM | |
2 | 2 | John | Smith | John.Smith@email.com | |
3 | 3 | David | Chen | david.chen@email.com | |
4 | 4 | Samantha | Baker | SAMANTHA.BAKER@EMAIL.COM | |
5 | 5 | Emily | Rodriguez | EMILY.RODRIGUEZ@EMAIL.COM | |
6 | 6 | Michael | Williams | michael.williams@email.com |
Problem:
The emails are not uniform. To standardize them, you can create a new column with all email addresses converted to lowercase.
Solution:
You can use the LOWER function to create a new, standardized column. This will convert all the email addresses to lowercase, making the data consistent.
Resulting Spreadsheet:
The LOWER function converts the text in column D to lowercase in the new column E.
Customer ID | First Name | Last Name | Standardized Email | |||
|---|---|---|---|---|---|---|
A | B | C | D | E | ||
1 | 1 | Jane | Doe | JANE.DOE@EMAIL.COM | jane.doe@email.com | |
2 | 2 | John | Smith | John.Smith@email.com | john.smith@email.com | |
3 | 3 | David | Chen | david.chen@email.com | david.chen@email.com | |
4 | 4 | Samantha | Baker | SAMANTHA.BAKER@EMAIL.COM | samantha.baker@email.com | |
5 | 5 | Emily | Rodriguez | EMILY.RODRIGUEZ@EMAIL.COM | emily.rodriguez@email.com | |
6 | 6 | Michael | Williams | michael.williams@email.com | michael.williams@email.com |
This demonstrates how a simple function like LOWER can be a powerful tool for cleaning and standardizing messy data in a spreadsheet.
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof