The CONCAT function
Joins texts and ranges into one text. The & operator does the same for single cells.
Syntax
CONCAT(text1, [text2], ...)- text1
- The first text, cell or range.
- text2 (optional)
- More texts or ranges.
Examples
D1
=CONCAT(1A2,2" ",3B2)| A | B | C | D | |
|---|---|---|---|---|
| 1 | First | Last | Anna Berg | |
| 2 | Anna | Berg |
In plain words: Join 1the first name in A2, 2a space and 3the last name in B2.
D1=CONCAT(A2:B2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | First | Last | AnnaBerg | |
| 2 | Anna | Berg |
Questions
Does CONCAT work in Google Sheets?
Only for two values. Google Sheets' CONCAT joins exactly two values and takes no ranges, so use CONCATENATE or TEXTJOIN there to join more.