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"