Description
Use this function to convert all the characters in a text string to lowercase. Supported in Chains.
LOWER is useful for standardizing text data to ensure consistency in text processing and comparisons.
Syntax
LOWER(text)
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
text |
Yes | The text string that you want to convert to lowercase. | A text string, a reference to a cell containing text, or a formula which results in either of these. |
Example
Sample data
| A | B | ||
|---|---|---|---|
1 |
1 |
HELLO |
|
2 |
2 |
WORLD |
|
3 |
3 |
Roundelay |
|
4 |
4 |
Function |
Sample Formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Convert the text in a cell to all lowercase letters. | =LOWER(A1) |
Converts every character in "HELLO" to lowercase. Result: hello |
| Convert a specific piece of text you type directly into the formula to lowercase. | =LOWER("WORLD") |
Converts the literal text "WORLD" to lowercase instead of pulling from a cell. Result: world |
| Standardize a mixed-case word to all lowercase. | =LOWER(A3) |
Converts every character in "Roundelay" to lowercase. Result: roundelay |
| Standardize a phrase with inconsistent capitalization to all lowercase. | =LOWER("ANnual REport") |
Converts every character in "ANnual REport" to lowercase, regardless of the mixed-up capitalization. Result: annual report |
Notes
- LOWER does not change any non-text characters within the string.
- LOWER can be used with other functions to ensure text consistency in data analysis.
- LOWER is case-sensitive, meaning it will convert all uppercase letters to lowercase but leave existing lowercase letters unchanged.
Tips
- LOWER can be combined with other text functions such as UPPER and PROPER to manipulate text case as needed.
- LOWER can help create standardized data formats, which is useful in data validation and cleanup tasks.
- Use LOWER to prepare text data for case-insensitive comparisons.