JOIN in Google Sheets
Joins the values of a row or column into one text, with a delimiter between them.
Syntax
JOIN(delimiter, value1, [value2], ...)- delimiter
- The text between the values, such as ", ".
- value1
- A value, or a range of one row or one column.
- value2 (optional)
- More values or ranges.
Examples
C1
=JOIN(1", ",2A2:A4)| A | B | C | |
|---|---|---|---|
| 1 | Tag | sale, new, gift | |
| 2 | sale | ||
| 3 | new | ||
| 4 | gift |
In plain words: Join 2the tags in A2:A4 with 1a comma and a space between them.
B1=JOIN("-","DK","2100")
| A | B | |
|---|---|---|
| 1 | DK-2100 |