Excel UPPER Function

Using the Excel UPPER Function

Excel UPPER Function

Summary

The Excel UPPER function will convert all lowercase letters in a text string to uppercase letters.

Syntax

=UPPER (text)

Syntax Breakdown

Text
Required. The text that will be changed to uppercase. The function has no affect on characters in text that are not letters. The argument can be a reference or a text string.

Usage Notes

UPPER changes lowercase letters in a text string to uppercase letters. Non-text characters, such as punctuation and numbers, are not affected.

To convert uppercase letters to lowercase, use the LOWER function.