I have been encountering the issue thanks for tutoring
@datacense6 ай бұрын
You're welcome
@sreejayalamanchili50636 ай бұрын
Does it work only for columns?? Bcoz I have entered the formula to split a cell having text Ex: A1 - John Adam Marlin And now to split this I entered a formula =Textsplit(A1,{" "}) But it is still showing spill error even though there is no data to obstruct in the entire sheet....is there any hidden rules like it works only for row or a column...or is my formula wrong anywhere...please let me know if I am wrong