Spread Formula Reference
Formula Functions / Functions T to Z / UPPER
In This Topic
    UPPER
    In This Topic

    This function converts text to uppercase letters.

    Syntax

    UPPER(string)

    Arguments

    The argument is the text you want to convert to uppercase. The argument may be a string, a reference to a cell containing a string, or a formula that returns a string.

    Remarks

    This function does not change characters in value that are not letters.

    Data Types

    Accepts string data. Returns string data.

    Examples

    UPPER(G15)

    UPPER(R15C7)

    UPPER("Report") gives the result REPORT

    UPPER(""summary"") gives the result "SUMMARY"

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    PROPER | LOWER | T | Text Functions