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"
