Upper() function

The Excel UPPER function returns a upper-case version of a given text string. Numbers and punctuation are not affected.

Syntax

The syntax for the UPPER function in Microsoft Excel is:

=UPPER( text )

Parameters or Arguments

text

The string that you wish to convert to uppercase.

Upper Function Examples

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

Formulas:

Results:

Excel Function Home

Text Functions