As on date: April 23, 2024, TEXTSPLIT function does not work on dynamic arrays (requires only one element as input) and needs to be combined with other functions in order to make it work. On stackoverflow I could find a workaround solution using REDUCE. But I think it should work out-of-the-box preferably like =TEXTSPLIT(array,";") (it only returns first element in each row (just before first delimiter) instead of all elements in all rows spilled over all required number of columns) or in MAP-LAMBDA combination like this: =MAP(array,LAMBDA(x,TEXTSPLIT(x,";"))) - It yields #CALC! error at present. Same when I tried to use like this: =DROP(SCAN("",array,LAMBDA(x,y,VSTACK(x,TEXTSPLIT(y,";")))),1). When I use REDUCE in place of SCAN, it works. This inconsistency needs to be removed. Not only TEXTSPLIT but all other similar functions like TEXTJOIN, TEXTBEFORE, TEXTAFTER, etc. should work on dynamic arrays using MAP-LAMBDA and other functions like SCAN - Without involving other supplimentary functions like vstack, drop, reduce, etc.