Text
CONCAT
Definition
CONCAT returns text joined from the pieces you give it, with no delimiter added.
Syntax
=CONCAT(text1, [text2], ...)
Arguments
| Argument | Meaning |
|---|---|
text1 |
The first text, cell, or range to join. |
text2, ... |
Optional extra text, cells, or ranges to join after the first. |
Worked example
A stock sheet builds a code from a prefix and a number. Prefixes are in A2:A4 and numbers are in B2:B4.
| A: Prefix | B: Number |
|---|---|
| PX | 19 |
| PX | 20 |
| QT | 7 |
Formula: =CONCAT(A2,"-",B2)
Result: PX-19. The hyphen is typed in the formula, because CONCAT does not insert a delimiter on its own.
Practice
Cell A2 holds Hi and cell B2 holds !. In C2, write a formula that joins those two cells.
- In C2, write a CONCAT formula that joins A2 and B2.
- C2 should show A2 and B2 joined.
Step 1 of 2
Enter =CONCAT(A2,B2) in C2.
Hi joined with ! is Hi!.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
C2 uses CONCAT.
C2 now shows Hi!.
Related functions
TEXTJOIN joins pieces with a delimiter and can skip empty cells. LEFT can then take a prefix from the joined text.
Common mistake
Expecting CONCAT to insert commas or spaces: =CONCAT(A2,B2) on PX and 19 returns PX19, with nothing extra between the pieces.