LOWER¶
Converts the letters of a given string to lowercase. To convert text to uppercase please refer to UPPER.
Syntax
=LOWER(Text)
Arguments
Name |
Description |
---|---|
Text |
A string to convert to lowercase |
Return Value
Given text in lowercase.
Example
Function |
Result |
Comment |
---|---|---|
=LOWER(“HeLLo!”) |
hello! |
only affects letters in uppercase |
=LOWER(A1) |
hello world |
assumes cell A1 contains text “Hello WORLD” |