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...
You're seeing the infamous array of arrays limitation.
https://exceljet.net/glossary/array-of-arrays#:~:text=%22Array%20of%20arrays%22%20is%20a%20name%20for%20a,the%20example%29%20or%20an%20error%20in%20some%20cases.
https://exceljet.net/glossary/array-of-arrays#:~:text=%22Array%20of%20arrays%22%20is%20a%20name%20for%20a,the%20example%29%20or%20an%20error%20in%20some%20cases.