The Excel UPPER Function

Home » Excel-Built-In-Functions » Excel-Text-Functions » Excel-Upper-Function Search this site: Custom Search

Related Functions:  LOWER Function PROPER Function

Basic Description

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

The format of the function is :

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.

Formulas

Results

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