---
title: "CONCAT function in Excel: syntax and examples | ExcelSavvy"
description: "How to use CONCAT in Excel: join first and last names, codes and other text into one cell, with examples."
canonical_url: "https://excelsavvy.com/functions/concat"
meta:
  "og:description": "How to use CONCAT in Excel: join first and last names, codes and other text into one cell, with examples."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09OQ0FUIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT05DQVQgaW4gRXhjZWw6IGpvaW4gZmlyc3QgYW5kIGxhc3QgbmFtZXMsIGNvZGVzIGFuZCBvdGhlciB0ZXh0IGludG8gb25lIGNlbGwsIHdpdGggZXhhbXBsZXMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09OQ0FUKHRleHQxLCBbdGV4dDJdLCAuLi4p%2Cp_Ii9mdW5jdGlvbnMvY29uY2F0Ig%2Cs_xffDMzR8QgxSrerR.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "CONCAT function in Excel: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09OQ0FUIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT05DQVQgaW4gRXhjZWw6IGpvaW4gZmlyc3QgYW5kIGxhc3QgbmFtZXMsIGNvZGVzIGFuZCBvdGhlciB0ZXh0IGludG8gb25lIGNlbGwsIHdpdGggZXhhbXBsZXMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09OQ0FUKHRleHQxLCBbdGV4dDJdLCAuLi4p%2Cp_Ii9mdW5jdGlvbnMvY29uY2F0Ig%2Cs_xffDMzR8QgxSrerR.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **The CONCAT function**

Joins texts and ranges into one text. The & operator does the same for single cells.

=

CONCAT(

## **How to use CONCAT**

CONCAT glues pieces of text together into one cell, like taping strips of paper end to end. Each argument is a strip: a cell, a piece of text in quotes or a whole range. CONCAT adds nothing between the strips, so you put in the spaces and commas yourself.

The classic job is names. With first names in column A and last names in column B, `**=CONCAT(A2," ",B2)**` gives Anna Berg. The space is text, so it goes in quotes as its own argument. You can also build a product code from a prefix and a number, an email address from a name and a company domain, or a sentence like `**=CONCAT("Invoice ",A2," is due")**`.

Unlike the & operator, CONCAT accepts a whole range. `**=CONCAT(A2:B2)**` joins every cell in it, but with nothing in between, so you get AnnaBerg. That suits a row of letters or digits and fits badly when every piece needs a space or comma. For that, use TEXTJOIN, which takes the separator once. For two or three cells, the & operator is just as short: `**=A2&" "&B2**`.

Numbers and dates come through as their raw values, so wrap them in TEXT when they need to look right.

## **Syntax**

```
CONCAT(text1, [text2], ...)
```

<dl><dt>**text1 **</dt>
<dd>The first text, cell or range.</dd>
<dt>**text2 **(optional)</dt>
<dd>More texts or ranges.</dd></dl>

## **Examples**

D1`=CONCAT(<sup>1</sup>A2,<sup>2</sup>" ",<sup>3</sup>B2)`

|  | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | First | Last |  | **Anna Berg** |
| 2 | Anna | Berg |  | |

**In plain words:** Join <sup>1</sup>the first name in A2, <sup>2</sup>a space and <sup>3</sup>the last name in B2.

D1=CONCAT(A2:B2)

|  | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | First | Last |  | **AnnaBerg** |
| 2 | Anna | Berg |  | |

## **Common CONCAT mistakes**

- The names run together, like AnnaBerg

  CONCAT puts nothing between the pieces. Add a space as its own argument: `**=CONCAT(A2," ",B2)**`. For a whole range with a space between every cell, use `**=TEXTJOIN(" ",TRUE,A2:B2)**`.
- A date or percentage turns into a plain number

  CONCAT uses the raw value of the cell, and a date is a number underneath. Format it with TEXT: `**=CONCAT("Due: ",TEXT(A2,"mmm d, yyyy"))**`, or `**TEXT(B2,"0%")**` for a percentage.
- There is a double space when the middle name is empty

  The empty cell still gets its space. Wrap the result in TRIM, as in `**=TRIM(CONCAT(A2," ",B2," ",C2))**`, or use `**=TEXTJOIN(" ",TRUE,A2:C2)**`, which skips empty cells.
- The joined result looks like a number but will not add up or match

  CONCAT always returns text, even when every piece is a digit. Wrap it in VALUE when you need a real number: `**=VALUE(CONCAT(A2,B2))**`.

## **Read the guide**

- [**How to merge cells in Excel, and what to use instead**](https://excelsavvy.com/learn/merge-cells-excel)

## **Questions**

<details>

<summary>

### What is the difference between CONCAT and CONCATENATE?

</summary>

CONCATENATE is the older function and cannot join a whole range. CONCAT can, and it arrived with Excel 2019. Very old versions of Excel have only CONCATENATE and the &amp; operator.

</details>

<details>

<summary>

### Does CONCAT work in Google Sheets?

</summary>

Only for two values. Google Sheets' CONCAT joins exactly two values and takes no ranges, so use CONCATENATE or TEXTJOIN there to join more.

</details>

<details>

<summary>

### Should I use CONCAT or TEXTJOIN?

</summary>

Use CONCAT for a few pieces with no separator, and TEXTJOIN when you need the same separator between every piece or want to skip empty cells. =TEXTJOIN(", ",TRUE,A2:A6) lists a range with commas.

</details>

<details>

<summary>

### How do I put a line break between two joined values?

</summary>

Join in CHAR(10), as in =CONCAT(A2,CHAR(10),B2), and turn on Wrap Text for the cell so the break shows.

</details>

## **Related functions**

- [**TEXTJOIN**](https://excelsavvy.com/functions/textjoin)
- [**TEXT**](https://excelsavvy.com/functions/text)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/functions/concat#webpage","dateModified":"2026-11-16","description":"How to use CONCAT in Excel: join first and last names, codes and other text into one cell, with examples.","name":"CONCAT function in Excel: syntax and examples","url":"https://excelsavvy.com/functions/concat","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/functions/concat#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/functions/concat#/schema/question/1"},{"@id":"https://excelsavvy.com/functions/concat#/schema/question/2"},{"@id":"https://excelsavvy.com/functions/concat#/schema/question/3"},{"@id":"https://excelsavvy.com/functions/concat#/schema/question/4"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/functions/concat"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/functions/concat#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://excelsavvy.com/functions","position":2},{"@type":"ListItem","name":"CONCAT function in Excel: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/functions/concat#article","dateModified":"2026-11-16","description":"How to use CONCAT in Excel: join first and last names, codes and other text into one cell, with examples.","headline":"CONCAT function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09OQ0FUIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT05DQVQgaW4gRXhjZWw6IGpvaW4gZmlyc3QgYW5kIGxhc3QgbmFtZXMsIGNvZGVzIGFuZCBvdGhlciB0ZXh0IGludG8gb25lIGNlbGwsIHdpdGggZXhhbXBsZXMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09OQ0FUKHRleHQxLCBbdGV4dDJdLCAuLi4p%2Cp_Ii9mdW5jdGlvbnMvY29uY2F0Ig%2Cs_xffDMzR8QgxSrerR.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/functions/concat#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/functions/concat#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/functions/concat#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is the difference between CONCAT and CONCATENATE?","acceptedAnswer":{"@type":"Answer","text":"CONCATENATE is the older function and cannot join a whole range. CONCAT can, and it arrived with Excel 2019. Very old versions of Excel have only CONCATENATE and the & operator."}},{"@id":"https://excelsavvy.com/functions/concat#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Does CONCAT work in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"Only for two values. Google Sheets' CONCAT joins exactly two values and takes no ranges, so use CONCATENATE or TEXTJOIN there to join more."}},{"@id":"https://excelsavvy.com/functions/concat#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Should I use CONCAT or TEXTJOIN?","acceptedAnswer":{"@type":"Answer","text":"Use CONCAT for a few pieces with no separator, and TEXTJOIN when you need the same separator between every piece or want to skip empty cells. =TEXTJOIN(\", \",TRUE,A2:A6) lists a range with commas."}},{"@id":"https://excelsavvy.com/functions/concat#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"How do I put a line break between two joined values?","acceptedAnswer":{"@type":"Answer","text":"Join in CHAR(10), as in =CONCAT(A2,CHAR(10),B2), and turn on Wrap Text for the cell so the break shows."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09OQ0FUIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT05DQVQgaW4gRXhjZWw6IGpvaW4gZmlyc3QgYW5kIGxhc3QgbmFtZXMsIGNvZGVzIGFuZCBvdGhlciB0ZXh0IGludG8gb25lIGNlbGwsIHdpdGggZXhhbXBsZXMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09OQ0FUKHRleHQxLCBbdGV4dDJdLCAuLi4p%2Cp_Ii9mdW5jdGlvbnMvY29uY2F0Ig%2Cs_xffDMzR8QgxSrerR.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Q09OQ0FUIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBDT05DQVQgaW4gRXhjZWw6IGpvaW4gZmlyc3QgYW5kIGxhc3QgbmFtZXMsIGNvZGVzIGFuZCBvdGhlciB0ZXh0IGludG8gb25lIGNlbGwsIHdpdGggZXhhbXBsZXMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Q09OQ0FUKHRleHQxLCBbdGV4dDJdLCAuLi4p%2Cp_Ii9mdW5jdGlvbnMvY29uY2F0Ig%2Cs_xffDMzR8QgxSrerR.png"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
