What is the UPPER Function
The UPPER function converts all lowercase letters in a text string to uppercase. It is useful for standardizing text, especially codes and IDs.
Formula: =UPPER(text)
Practical Example 1
A2 contains excel.
Type: =UPPER(A2)
Result: EXCEL
Practical Example 2
Standardize product codes to uppercase.
Type: =UPPER(A2)
Result: the code in uppercase
Practical Example 3
Combine with TRIM to standardize IDs.
Type: =UPPER(TRIM(A2))
Result: the ID cleaned and in uppercase
When to Use It
UPPER is used for standardizing text codes, for formatting product IDs, for making data consistent before matching, and for any formula where uppercase output is needed.