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 | HELLO |
| 2 | WORLD |
| 3 | Roundelay |
| 4 | Function |
Sample Formulas
| Formula | Description | Result |
|---|---|---|
=LOWER(A1) |
Converts the text in cell A1 to lowercase. | hello |
=LOWER("WORLD") |
Converts the string "WORLD" to lowercase. | world |
=LOWER(A3) |
Converts the text in cell A3 to lowercase. | roundelay |
=LOWER("ANnual REport") |
Converts the string "ANnual REport" to lowercase. |
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.
Related functions
CHAR
CODE
CONCATENATE
CONCATENATEIF
FIND
LEFT
LEN
LOWER
MID
PROPER
REPT
RIGHT
SEARCH
SUBSTITUTE
TEXT
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER