Combining TEXTSPLIT with BYROW to return a spilled array [duplicate]

Question

I can use TEXTSPLIT() on an individual cell with no problem, but I want to use a single formula to split a list of names.

This works:

However, this doesn't:

What am I doing wrong? BYROW() works fine with most functions, but it doesn't like TEXTSPLIT() for some reason.

What is the solution?

Answer 1

The error is due to the fact that, when using BYROW, the LAMBDA must return only a single value, not two values.

There may be more efficient methods, but one way of getting your desired output to spill over the range with just a single formula:

 =HSTACK(TEXTBEFORE(F2:F4," "),TEXTAFTER(F2:F4," "))