SPLIT not spliting

[benjamin_gunter]

peace Everyone,

I’m not seeing the results i’m expecting when doing a SPLIT:

I get the first column, but the second column is not getting populated

thanks in advance for any assistance with this.

[msiraj]

We do not support Array SPILL behavior as of today.

As an alternative, request you to explicitly define formulas in both adjacent column cells to populate with specific array values resulting from SPLIT.

Using INDEX here to pick result array’s second element.