The LOWER function returns a string where all letters are lowercase.
This function can be useful when you need to standardize the format of text, for example, for data processing or report preparation.
Syntax
LOWER(string)
Argument |
Description |
Permitted values |
|---|---|---|
string |
Text string that needs to be lowercase |
Text string or reference to a cell containing text |
Examples of use
Convert text to lowercase
If cell A1 contains the text “Hello, WORLD”:
=LOWER(A1)
The result: "hello, world".
Combining with other functions
If you want to combine several text strings and convert them to lowercase:
=LOWER(CONCATENATE("HELLO, ", "WORLD"))
The result: "hello, world".
Notes
–The LOWER function is useful for processing data when it is important for the text to be in one case, for example, when comparing strings.
–If the text is already in lowercase, the function will not change it.