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:


