TEXTJOIN
Joins a list with a separator between each item.
How it’s written
TEXTJOIN(separator, skip_blanks, range)Example
| A | |
|---|---|
| 1 | Team |
| 2 | Amara |
| 3 | Ben |
| 4 | Chloe |
=TEXTJOIN(", ",TRUE,A2:A4)Result: Amara, Ben, Chloe
Joins the three names with a comma and a space.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
TRUE skips empty cells, so blanks don’t leave double commas.
Practice it properly
Joining text together gives you real tasks, with your formulas tested on data you haven’t seen.