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.

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Examples of use of the Excel Upper Function
Excel Upper Function Results

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