Hi
I have a
So far all I can think of is joining, then splitting using TEXTSPLIT specifying no column delimiter using an arbitrary symbol like ¦.
It's not very elegant because I have to add that ¦ symbol to the text, and also it adds a space at the beginning of all rows except the first.
Is there a better way?
I have a
CHOOSECOLS
function that returns an array of two columns, and I want to merge/join each row so that I'm left with one column.ARRAYTOTEXT
and TEXTJOIN
seem limited to join the whole lot into one cell, which I don't want.So far all I can think of is joining, then splitting using TEXTSPLIT specifying no column delimiter using an arbitrary symbol like ¦.
Excel Formula:
=TEXTSPLIT(TEXTJOIN(". ",TRUE,CHOOSECOLS(array,9,5)),,"¦.")
It's not very elegant because I have to add that ¦ symbol to the text, and also it adds a space at the beginning of all rows except the first.
Is there a better way?