UPPER Function - Excel


Overview


The UPPER function in Excel is a useful tool for converting all the lowercase letters in a text string to uppercase. This function provides a way to standardize the case of text, making it consistent and easy for comparisons when using lookup and reference functions.

An example of the UPPER function in Excel

Example:

=UPPER("apple")

Syntax:

=UPPER(text)

text: This is the text string or cell reference containing the text you want to convert to uppercase.


Example


In this example, the UPPER function takes the word “hiking” and switches all the lowercase letters to uppercase, giving us a final output of “HIKING”.

Another example of the UPPER function in Excel

Interactive GSheet