SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / LOWER
In This Topic
    LOWER
    In This Topic

    This function converts text to lower case letters.

    Syntax

    LOWER(string)

    Arguments

    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.

    Data Types

    Accepts string data. Returns string data.

    Examples

    LOWER(A4)

    LOWER(R4C1)

    LOWER(""Road Race 2"") gives the result road race 2

    LOWER(CONCATENATE(A1,A5))

    See Also