Use

The TextJoin() function combines the items in an array into a text value, with a given delimiter between each item.

The items in the array are expected to be text values, but if the items are number values, they will be converted into text values.

For two-dimensional arrays, the items are combined left to right, then top to bottom. TextJoin2() works similarly, but you can use a different delimiter for columns and rows.

Examples

• TextJoin(";", ["A"; "B"; "C"])  = "A;B;C"
• TextJoin(" ", ["wish", "me"; "good", "morning"])  = "wish me good morning"