Combine text with a separator
Glue several cells into one string with a delimiter between each.
The formula
=TEXTJOIN(", ", TRUE, A2:A4)How it works
Paris+Lyon+Nice
→
Result
Paris, Lyon, Nice
TEXTJOIN joins items with a delimiter between each (here a comma and a space).


