Forum Discussion

Franstel's avatar
Franstel
Copper Contributor
May 15, 2024

Text join

I do not understand this syntax. Where is the

delimiter

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    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.

Resources