Text
CONCAT function playground
Joins text from several cells or values into one piece of text.
The playground runs in your browser. Nothing you type is sent anywhere.
How CONCAT works
CONCAT sticks the pieces together in order, with nothing in between. Add spaces or punctuation yourself as text in quotes, such as " " or ", ".
CONCAT also accepts ranges, unlike the older CONCATENATE. The & operator does the same job: =B2&" "&C2.
Syntax
=CONCAT(text1, [text2], ...)| Argument | What it means |
|---|---|
text1required | The first text, cell or range to join. |
text2, ...optional | More text, cells or ranges. |
Examples
| Formula | What it does | Result |
|---|---|---|
=CONCAT(B2," ",C2) | First and last name with a space. | Grace Kim · Omar Haddad · Lily Chen · Jonas Berg … |
=CONCAT(C2,", ",B2) | Last name first. | Kim, Grace · Haddad, Omar · Chen, Lily · Berg, Jonas … |
=B2&" "&C2 | The & operator gives the same result. | Grace Kim · Omar Haddad · Lily Chen · Jonas Berg … |
=CONCAT(B2:C2) | A whole range, joined with no separator. | GraceKim · OmarHaddad · LilyChen · JonasBerg … |
Common mistakes
Missing spacesCONCAT doesn't add spaces. Include " " between pieces.
Numbers lose their formatA date or currency becomes a plain number. Wrap it in TEXT first.
Related functions
Learn more
Download the example workbook (.xlsx)
The workbook has the same sample data and formulas, plus a practice sheet.