Join two or more text strings together.

CONCAT(text1, [text2], …)

---

CONCAT has replaced the CONCATENATE function used by older versions of Excel. It is available in Office 2019 or Office 365 subscriptions.

Join two or more text strings together using either defined values (e.g. "string") or cell references (e.g. C3) or a range (e.g. C3:C7).

CONCAT syntax does NOT provide for delimiter or empty cell arguments, unlike the TEXTJOIN function.

---

CONCAT with a text string.

In the examples below, the CONCAT function is used to form sentences using a mix of defined values and cell references from the table to the left.

---

CONCAT with a number.

In the examples below, the CONCAT function is used to join numbers and text together in sentences. Calculations (in this case division) and number formatting (here using the TEXT function) can be embedded within a CONCAT formula.

---

CONCAT with a cell range.

In the examples below, the CONCAT function is used to join a range of text together to form sentences. Spaces have been included after the relevant words as delimiters are not available in the CONCAT function.

---

Syntax

CONCAT(text1, [text2], …)

The CONCAT function consists of 2 or more arguments:

1. text1. Required. The first item to join.
2. text2. Optional. Additional items to join.

---

Try it now!

Enter your formulas into the grey cells.

---

Scope

CONCAT can be applied to cell references, ranges or text or number constants.

Text:	=CONCAT("South"&" "&"America") || returns South America.
Number:	=CONCAT(10,20,30) || returns 102030 as a text value.
Cell reference:	=CONCAT(C7," is the largest country by population in ",D7) || returns the contents of cell C7, the text string and the contents of cell D7.
Cell range:	=CONCAT(C3:C7) || returns the contents of cells in the range C3:C7.

Caveats

• The CONCAT function joins up to 253 text items together, up to a total of 32,767 characters.
• The CONCAT function can handle cell ranges, unlike the older CONCATENATE function.
• Use commas to separate text items.
• Empty cells are ignored.
• #VALUE! is returned if the concatenated string exceeds 32,767 characters (cell limit).
• Spaces may need to be added between or after values as delimiter arguments are not available.
  • e.g. =CONCAT("South"," ","America") || space added as text value; returns South America.
  • e.g. =CONCAT("South ","America") || space added after South; returns South America.
• Numbers are converted to text when joined and formatting is not retained.
  • Use the TEXT function to format numbers within a CONCAT formula.
  • e.g. =CONCAT("The GDP per capita in USD of ",C7," is ",TEXT(D7,"$#,##0.00"))
• To display quotation marks, enter "" inbetween "" (e.g. """") to return ".
• #NAME? usually means quotation marks ("") are missing.
• Using the ampersand (&) calculation operator achieves the same result as the CONCAT function.
  • e.g. ="South"&" "&"America" returns South America.

---

Related Functions

• TEXTJOIN joins text from multiple ranges and/or strings and includes an optional delimiter.

Functions Category

• Text