Documentation/Calc Functions/LOWER

    From The Document Foundation Wiki
    Other languages:


    Function name:

    LOWER

    Category:

    Text

    Summary:

    Converts uppercase characters in a supplied text string to lowercase.

    Syntax:

    LOWER(Text)

    Returns:

    Returns a text string that corresponds to the supplied text string, with uppercase characters converted to lowercase.

    Arguments:

    Text is a text string (in quotation marks) or a reference to a cell containing a text string, that is the string to be converted to lowercase.

    Additional details:

    The operation of LOWER depends on locale settings and so it should not be regarded as portable.

    In addition to converting uppercase characters in the range [A…Z] to lowercase characters in the range [a…z], LOWER also converts many other characters.


    The Unicode Standard contains much information about case conversion. The following sections of the standard are relevant:

    The three links above lead to sections within the documentation for Unicode 5.2.0, which is the legacy version of the standard that is referenced in ODF 1.2. The latest version of the Unicode Standard can be found via the Unicode public website.

    Examples:

    Formula Description Returns
    =LOWER("Good MORNING") Here the function converts the uppercase letters to lowercase and returns "good morning". good morning
    =LOWER(D1) where cell D1 contains the string "Sun". Here the function converts the uppercase letter to lowercase and returns "sun". sun

    Related LibreOffice functions:

    PROPER

    UPPER

    ODF standard:

    Section 6.20.14, part 2

    Related (or similar) Excel functions:

    LOWER