Forum Discussion
dipankar_de
Nov 12, 2022Copper Contributor
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...
Anonymous
Jun 30, 2025=HSTACK(Table2['#],IFERROR(TEXTSPLIT(TEXTJOIN("|",,Table2[Values]),";","|"),""))