Beginner

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).

Functions used