LOWER
Converts the letters of a given string to lowercase. To convert text to uppercase please refer to UPPER.
Syntax
=LOWER(Text)
Arguments
| Name | Type | Description |
|---|---|---|
| Text | String | A string to convert to lowercase |
Return
| Type | Description |
|---|---|
| String | Given text in lowercase. |
Examples
| Formula | Result | Comment |
|---|---|---|
| hello! | only affects letters in uppercase |
| hello world | assumes cell A1 contains text "Hello WORLD" |