Spreadsheet formulas explained, side by side

CONCATENATE Function in Excel, Google Sheets, Airtable & Notion

CONCATENATE joins pieces of text into one string. The & operator does the same job and is usually shorter: =A2&" "&B2 turns “Ada” and “Lovelace” into “Ada Lovelace”.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inCONCATENATE(text1, [text2], ...)
Also text1 & text2, and CONCAT(text1, ...) (Excel 2019 / 365), which accepts whole ranges.
Google Sheets✔ Built inCONCATENATE(string1, [string2, ...])
& works too. Sheets' CONCAT takes exactly two values, so use CONCATENATE or & for more.
Airtable✔ Built inCONCATENATE(text1, [text2, ...])
Or {First} & " " & {Last}. Format dates with DATETIME_FORMAT() before joining them.
Notion✔ Built intext1 + text2 + ...
Join text with +. Wrap numbers and dates in format() first, e.g. "Total: " + format(prop("Amount")). Notion's concat() joins lists, not text.
Try CONCATENATE with your own values
A single space by default; try ", " or "-"
Result (as Excel & Google Sheets return it)
Ada Lovelace 12 characters
Your formula, ready to paste
Excel=CONCATENATE("Ada", " ", "Lovelace") open excel.new ↗
Google Sheets=CONCATENATE("Ada", " ", "Lovelace") open sheets.new ↗
AirtableCONCATENATE("Ada", " ", "Lovelace")
Notion"Ada" + " " + "Lovelace"

Arguments

ArgumentWhat it means
text1The first piece of text, number or cell.
[text2], ... optionalMore pieces, joined in order with nothing in between. Add spaces or separators as their own arguments.

Examples

FormulaResultWhyCopy
=A2&" "&B2Ada LovelaceFirst and last name with a space between them. The & operator is the shortest form.
=CONCATENATE("Q", 3, "-", 2026)Q3-2026Numbers are converted to text.
=CONCAT(A2:C2)Row joinedExcel 2019+ CONCAT accepts a range, but adds no separator. Use TEXTJOIN for one.
="Total: "&TEXT(B2, "$#,##0.00")Total: $1,234.50With 1234.5 in B2. TEXT keeps the number format, which joining would otherwise lose.

Examples use Excel / Google Sheets syntax unless noted.

How CONCATENATE works

There are three ways to join text in Excel and Google Sheets and they give the same result: the & operator, CONCATENATE, and CONCAT. Most people use & because it is short and reads left to right. CONCATENATE is kept for compatibility. Excel's CONCAT (2019 and later) accepts ranges such as A2:C2, but Google Sheets' CONCAT joins exactly two values. None of them add a separator, so put " " or ", " in yourself, or use TEXTJOIN, which adds a delimiter and can skip blanks.

Joining turns everything into plain text, so numbers lose their formatting: a date becomes its serial number (45615) and 0.5 stays 0.5 rather than 50%. Wrap the value in TEXT() to keep the format: ="Due "&TEXT(A2, "d mmm yyyy").

Airtable has the same CONCATENATE() and &, applied to fields of one record. Notion joins text with +. Notion is stricter about types, so convert numbers and dates with format() before adding them to text.

Frequently Asked Questions

Why does my date turn into a number when I join it?
Dates are stored as numbers, and joining uses the raw value. Use TEXT(A2, "yyyy-mm-dd") (or any format code) inside the join.
How do I add a line break between joined values?
Join with CHAR(10), e.g. =A2&CHAR(10)&B2, and turn on Wrap text for the cell.

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