Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inUPPER(text)
Google Sheets✔ Built inUPPER(text)
Airtable✔ Built inUPPER(string)
Notion✔ Built inupper(text)
Try UPPER with your own values
Result (as Excel & Google Sheets return it)
INV-0042 PAID 13 characters
Your formula, ready to paste
Excel=UPPER("inv-0042 paid") open excel.new ↗
Google Sheets=UPPER("inv-0042 paid") open sheets.new ↗
AirtableUPPER("inv-0042 paid")
Notionupper("inv-0042 paid")

Arguments

ArgumentWhat it means
textThe text to convert.

Examples

FormulaResultWhyCopy
=UPPER("inv-0042 paid")INV-0042 PAID
=UPPER(LEFT(A2, 3))Code prefixA consistent upper-case code from a name.
=EXACT(A2, UPPER(A2))TRUE if all capsEXACT 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))).

Part of the Text functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.