Fix Spill errors in Excel

preview_player
Показать описание

Рекомендации по теме
Комментарии
Автор

I have been encountering the issue thanks for tutoring

kevinmitto
Автор

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

sreejayalamanchili