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.
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”.