The Excel UPPER Function

Related Functions:
LOWER Function
PROPER 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:

 Formulas:
  A B
1 test =UPPER( A1 )
2 TEST =UPPER( A2 )
3 Test =UPPER( A3 )
4 test 332 =UPPER( A4 )
 Results:
  A B
1 test TEST
2 TEST TEST
3 Test TEST
4 test 332 TEST 332

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