tech on the net

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

Type of Function

Worksheet Function Example

Let's take a look at an example to see how you would use the UPPER function in a worksheet:

Microsoft Excel

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"