How to Split from one cell to two cell?
Example:
A1: ABC: Apple Banana and Carrot
B1: ABC
C1: Apple Banana and Carrot
And how to include the arrayformula and leaveblank?
I tried this code: =index(SPLIT(A1,” “,true),1)
it shows only the ABC in the B1. It’s also not working for the whole column and there’s a word #VALUE! if it’s blank.