Excel UPPER function

Summary

The Excel UPPER function changes a text string to all upper case text string.

This function is useful for changing a text string to upper case characters for comparison purposes.

Function

=UPPER(text)

Arguments (inputs)

text = the text string, can be a cell reference or value

Return value

The UPPER function returns the same text string it is provided, but changed to an all upper case text string.

Example

In the example above the UPPER function changes the customer name from cell C6 “Claire Gute”, to all upper case characters.

=UPPER(C6)

The result returned is “CLAIRE GUTE”.