Search code examples
google-sheets

How to use ARRAYFORMULA with TEXTJOIN?

I have Google Sheet document and I use TEXTJOIN in it. I want to have my TEXTJOIN formula filled when i add new rows. But it doesn't work

enter image description here

So I tried to use ARRAYFORMULA. IT works with numbers:

enter image description here

But it still doesn't work with TEXTJOIN:

enter image description here

Any Ideas?

UPD: If I use & instead of TEXTJOIN it works but in fact i shoud use delimiter and I should avoid double delimiter. I shouldn't have any a--a or d-D-: enter image description here

Solution

  • Giving multiple array ranges to Arrayformula, and trying to force it to evaluate it in a specific order, is a losing battle. Try something simpler instead:

    =arrayformula(A1:A & " " & B1:B)

    enter image description here

    P.S. Your animated illustrations do show a level of effort on your part to ask a nice question, but frankly my eyes hurt from watching 3 cursors simultaneously, I'd prefer just the formulas or static images.