Text join

[Franstel]

I do not understand this syntax. Where is the

 

delimiter

[#2]

@Franstel Copy the example data from the help screen into an Excel sheet (cell A1) and then enter the formula somewhere below.

You'll see this:

The array A8:D8 holds the delimiters. I.e. commas that separate the cells from each row and a semi-colon separating rows.