Join a list with JOIN
PremiumIn B2, use JOIN to turn the tags in A2:A4 into one text, with a comma and a space between them.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Tag | Tags | ||||
| 2 | sale | |||||
| 3 | new | |||||
| 4 | gift | |||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock SPLIT and JOIN and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:REGEX functionsIF
Need help?
Why this works
JOIN puts the values of A2:A4 together in one text, with ", " between each pair. JOIN keeps empty cells, which would give two commas in a row; TEXTJOIN with TRUE skips them.
Common mistake: Putting the range first. JOIN takes the delimiter first, then the values.
The answer
- B2
=JOIN(1", ",2A2:A4)
In plain words: Join 2the tags in A2:A4 with 1a comma and a space between them.