CONCAT
Join text and cell values into one result
0 of 3 done · Lesson 17 of 18
Understand
People data arrives with first and last names in separate columns. CONCAT joins those values with any punctuation or spaces the final label needs.
=CONCAT(first text, next text, optional)
A worked example
=CONCAT(B3, " ", A3)
first textnext text
A3 is Walker and B3 is Amelia, so this returns Amelia Walker
The sheet you are working with
| Row number | A | B | C | D |
|---|---|---|---|---|
| 1 | Last name | First name | Team | Office |
| 2 | Singh | Priya | Finance | Wellington |
| 3 | Walker | Amelia | Sales | Auckland |
| 4 | Ropata | Hemi | Support | Hamilton |
| 5 | Chen | Leo | Operations | Christchurch |
| 6 | Martin | Sofia | Sales | Dunedin |
| 7 | Taylor | Noah | Support | Nelson |