Syntax
=UPPER(text)
text- The text to convert.
UPPER function in Google Sheets
UPPER converts all letters in text to capitals. Use it to standardise codes, abbreviations and IDs so they match consistently.
Practice UPPER
Task 1 of 1
Convert the state abbreviation in A2 to capitals. Answer in B2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
UPPER examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | |
|---|---|---|---|
| 1 | Raw name | SKU | Note |
| 2 | maya PATEL | ELC-0427-NY | Refund requested |
| 3 | leo rossi | FUR-1180-TX | Shipped |
| 4 | AVA KIM | OFC-0093-CA | Refund issued |
| Formula | Result | What it shows |
|---|---|---|
=UPPER(A3) | LEO ROSSI | All capitals. |
=UPPER(C2) | REFUND REQUESTED | Works on any text. |
=UPPER(LEFT(A3, 1)) | L | Just the first initial. |
Tips and common mistakes
- Numbers and punctuation are left unchanged.
- Lookups and COUNTIF already ignore case, so you only need UPPER for display or for EXACT comparisons.
Related functions
Learning step by step? UPPER is covered in Lesson 24: UPPER, LOWER & PROPER of the free course.