Forum Discussion
Using TEXTSPLIT without copy-fill-down
Hello All, I am trying to split "; " separated range of text into columns. The intent is to use one single spill-formula (instead of copy-fill-down) to address each text in the range. I have...
The array of arrays should not be a problem; it is simply the typical output from array calculation. Since the original date of this post, I have written helper functions (with a bit of tidying up from djclements ) that return arrays of arrays.
= MAPλ(values, LAMBDA(values, TEXTSPLIT(values, ";")))or by Currying the LAMBDA function
Worksheet formula
= MAPλ(values, TEXTSPLITλ(";"));
where
TEXTSPLITλ
= LAMBDA(s, LAMBDA(v, TEXTSPLIT(v, s)));The function MAPλ is to be found at
A version of Excel MAP helper function that will return an array of arrays