Table of Contents
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”.
