UPPER Function in Excel
Beginner
Converts all letters in a text string to uppercase.
Syntax
=UPPER(text)Example
Use Case
Standardize product codes to all caps.
Common Errors to Avoid
- Doesn't modify numbers or special characters
- Returns new value - doesn't change original cell
- Increases text length if source contains mixed case (display issue)
Pro Tips
Useful for data standardization before matching or lookups. Combine with TRIM to clean data: =UPPER(TRIM(A1)). Use PROPER for title case. For permanent conversion, copy results and Paste Special > Values.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →