The Excel UPPER Function

Basic Description

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

The format 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

The spreadsheet below shows four examples of the Upper function.

 Formulas:
 AB
1test=UPPER( A1 )
2TEST=UPPER( A2 )
3Test=UPPER( A3 )
4test 332=UPPER( A4 )
 Results:
 AB
1testTEST
2TESTTEST
3TestTEST
4test 332TEST 332

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