Syntax
UPPER(text)
| Parameter | Description |
|---|---|
| text | Parameter of the UPPER function. |
Examples
Convert text to uppercase
Formula
=UPPER(A2)
Returns: "JOHN SMITH" — converts "john smith" to all uppercase
Standardize state codes
Formula
=UPPER(TRIM(B2))
Returns: "CA" — converts and trims " ca " to a clean uppercase state code
Create uppercase product code
Formula
=UPPER(A2) & "-" & TEXT(B2, "0000")
Returns: "WIDGET-0042" — combines uppercase name with zero-padded number
Common Errors
#VALUE!
The argument is an error value, not text. Numbers are accepted and returned as-is (no letters to convert).
Tips
Case-insensitive comparison
=UPPER(A1)=UPPER(B1) compares text ignoring case. Or use =EXACT() for case-sensitive comparison.
Keyboard shortcut alternative
In some spreadsheets, you can select text and use a shortcut or menu to change case without formulas.
UPPER vs PROPER vs LOWER
UPPER: "HELLO WORLD". LOWER: "hello world". PROPER: "Hello World". Choose based on your formatting needs.
Try UPPER in Viztab
Import your data and use UPPER with 370+ other formulas. No signup required.
Open Viztab