Joining With Separators Using TEXTJOIN

In the last lesson you saw that CONCAT can join a range but cannot put a separator between each value.

Imagine you have a column of cities and you want them as one comma-separated list: Paris, Tokyo, Cairo. Doing that with CONCAT would mean typing each comma by hand.

TEXTJOIN solves this elegantly: you give it one delimiter, and it places that delimiter between every value automatically.

TEXTJOIN has three parts:

• delimiter the text placed between values, like ", "
• ignore_empty TRUE to skip blank cells, FALSE to keep them
• text1, text2, ... the cells or ranges to join

The shape is =TEXTJOIN(delimiter, ignore_empty, text1, ...). The delimiter is used only between items, never at the very start or end.