Forum Discussion
Text join
I do not understand this syntax. Where is the delimiter
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.