The Excel UPPER Function

Function Description

The Excel Upper function converts all characters in a supplied text string to upper case.

The syntax of the function is:

UPPER( text )

Where the text argument is the original text string, that you want to convert to upper case.

Upper Function Examples

Column B of the following spreadsheet shows the Excel Upper function, used to convert four text strings to upper case:

1test=UPPER( A1 )
3Test=UPPER( A3 )
4test 332=UPPER( A4 )
4test 332TEST 332

Further details and examples of the Excel Upper function are provided on the Microsoft Office website.