MS Excel: UPPER Function (WS)
In Microsoft Excel, the UPPER function allows you to convert text to all uppercase.
Syntax
The syntax for the UPPER function is:
UPPER( text )
text is the string that you wish to convert to uppercase.
Applies To
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
Worksheet Function Example
Let's take a look at an example to see how you would use the UPPER function in a worksheet:
Based on the Excel spreadsheet above, the UPPER function would return the following:
| =UPPER(A1) | would return "ALPHABET SOUP" |
| =UPPER(A2) | would return "TECHONTHENET.COM" |
| =UPPER("Excel") | would return "EXCEL" |
| =UPPER("123abc") | would return "123ABC" |