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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | CONCATENATE(text1, [text2], ...)Also text1 & text2, and CONCAT(text1, ...) (Excel 2019 / 365), which accepts whole ranges. |
| Google Sheets | ✔ Built in | CONCATENATE(string1, [string2, ...])& works too. Sheets' CONCAT takes exactly two values, so use CONCATENATE or & for more. |
| Airtable | ✔ Built in | CONCATENATE(text1, [text2, ...])Or {First} & " " & {Last}. Format dates with DATETIME_FORMAT() before joining them. |
| Notion | ✔ Built in | text1 + text2 + ...Join text with +. Wrap numbers and dates in format() first, e.g. "Total: " + format(prop("Amount")). Notion's concat() joins lists, not text. |
| Excel | =CONCATENATE("Ada", " ", "Lovelace") | open excel.new ↗ |
|---|---|---|
| Google Sheets | =CONCATENATE("Ada", " ", "Lovelace") | open sheets.new ↗ |
| Airtable | CONCATENATE("Ada", " ", "Lovelace") | |
| Notion | "Ada" + " " + "Lovelace" |
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 |
|---|---|
text1 | The first piece of text, number or cell. |
[text2], ... optional | More pieces, joined in order with nothing in between. Add spaces or separators as their own arguments. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=A2&" "&B2 | Ada Lovelace | First and last name with a space between them. The & operator is the shortest form. | |
=CONCATENATE("Q", 3, "-", 2026) | Q3-2026 | Numbers are converted to text. | |
=CONCAT(A2:C2) | Row joined | Excel 2019+ CONCAT accepts a range, but adds no separator. Use TEXTJOIN for one. | |
="Total: "&TEXT(B2, "$#,##0.00") | Total: $1,234.50 | With 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.