Documentation/Calc Functions/UPPER

    From The Document Foundation Wiki
    Other languages:


    Function name:

    UPPER

    Category:

    Text

    Summary:

    Converts lowercase characters in a supplied text string to uppercase.

    Syntax:

    UPPER(Text)

    Returns:

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

    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 uppercase.

    Additional details:

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

    In addition to converting lowercase characters in the range [a…z] to uppercase characters in the range [A…Z], UPPER 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
    =UPPER("Good Morning") Here the function converts the lowercase letters to uppercase and returns "GOOD MORNING". GOOD MORNING
    =UPPER(D1) where cell D1 contains the string "Sun". Here the function converts the lowercase letters to uppercase and returns "SUN". SUN

    Related LibreOffice functions:

    LOWER

    PROPER

    ODF standard:

    Section 6.20.27, part 2

    Related (or similar) Excel functions:

    UPPER