UPPER Function in Excel, Google Sheets, Airtable & Notion
UPPER converts every letter in a text string to uppercase. Numbers and punctuation are unchanged: “inv-0042 paid” becomes “INV-0042 PAID”.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | UPPER(text) |
| Google Sheets | ✔ Built in | UPPER(text) |
| Airtable | ✔ Built in | UPPER(string) |
| Notion | ✔ Built in | upper(text) |
| Excel | =UPPER("inv-0042 paid") | open excel.new ↗ |
|---|---|---|
| Google Sheets | =UPPER("inv-0042 paid") | open sheets.new ↗ |
| Airtable | UPPER("inv-0042 paid") | |
| Notion | upper("inv-0042 paid") |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
text | The text to convert. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=UPPER("inv-0042 paid") | INV-0042 PAID | ||
=UPPER(LEFT(A2, 3)) | Code prefix | A consistent upper-case code from a name. | |
=EXACT(A2, UPPER(A2)) | TRUE if all caps | EXACT compares case-sensitively; = does not. |
Examples use Excel / Google Sheets syntax unless noted.
How UPPER works
UPPER is used to make codes, IDs and country or currency codes consistent (“usd”, “Usd” → “USD”) before they are shown or exported. For comparisons it is usually unnecessary: =, VLOOKUP, MATCH and COUNTIF already ignore case in Excel and Google Sheets. When you do need a case-sensitive check, use EXACT() or FIND.
All four apps behave the same for ordinary letters, including accented ones (é → É). Airtable and Notion comparisons are case-sensitive, so UPPER({Code}) = "USD" or upper(prop("Code")) == "USD" is a useful way to match regardless of how the value was typed.
Frequently Asked Questions
- How do I capitalise only the first letter?
- For every word use PROPER. For just the first letter of the text:
=UPPER(LEFT(A2, 1))&LOWER(MID(A2, 2, LEN(A2))).