This function converts all lowercase letters in a text string to uppercase.
Syntax:
UPPER(text)
Arguments:
- text (required): The text you want to convert to uppercase.
Background:
The UPPER() function is useful for:
- Standardizing text data (e.g., converting names or codes to uppercase)
- Case-insensitive comparisons in formulas
- Preparing text for case-sensitive systems
Key Notes:
- Only affects alphabetic characters (a-z → A-Z)
- Leaves numbers, symbols, and existing uppercase letters unchanged
- Returns text values (even if input appears numeric)
Examples
| Formula | Result | Explanation |
| =UPPER(« Letters ») | « LETTERS » | Converts all letters to uppercase |
| =UPPER(« letters ») | « LETTERS » | Same as above |
| =UPPER(« Excel ») | « EXCEL » | Standardizes mixed case |
| =UPPER(« eXCEL ») | « EXCEL » | Converts all letters regardless of original case |
| =UPPER(« 1,232.56 ») | « 1,232.56 » | Numbers and punctuation remain unchanged |
Limitations
- Does not affect non-alphabetic characters
- Returns text values (may require VALUE() wrapper for numeric operations)
- For proper capitalization (e.g., « John Smith »), use PROPER() instead