Loading…
Loading…
CONCAT joins text from cells and ranges.
=CONCAT(text1, [text2], …)
| Argument | Required? | What it is |
|---|---|---|
| text1 | Required | The first text, cell or range to join. |
| text2, … | Optional | More text to join (optional). |
=CONCAT(A2," ",B2) joins first and last name with a space. =CONCAT(A2:B2) joins a range with no gaps.
From the lesson CONCAT Function.
Type the formula yourself and get it graded instantly, no Excel needed.