Beginner
Text
UPPER
Converts all letters in a text string to uppercase.
Compatibility: All Excel versions
Syntax
=UPPER(text)
Example
=UPPER(A1)
When to Use It
Use UPPER to standardize text formatting — e.g. converting inconsistent product codes to all-uppercase so they match reliably in comparisons.