Excel: Upper Function

In Excel, the Upper function allows you to convert text to all uppercase.

The syntax for the Upper function is:

Upper( text )

text is the string that you wish to convert to uppercase.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Upper(A1) would return "ALPHABET SOUP"

=Upper(A2) would return "TECHONTHENET"

=Upper("Excel") would return "EXCEL"

=Upper("123abc") would return "123ABC"