Formula Functions > Functions H to L > LOWER |
This function converts text to lower case letters.
LOWER(string)
The argument is the text you want to convert to lower case. This function does not change characters in value that are not letters.The argument may be a string, a reference to a cell containing a string, or a formula that returns a string.
Accepts string data. Returns string data.
LOWER(A4)
LOWER(R4C1)
LOWER(""Road Race 2"") gives the result road race 2
LOWER(CONCATENATE(A1,A5))
This function is available in product version 1.0 or later.
UPPER | T | Text Functions