TEXTSPLIT and BYROW were both released earlier this year.
The former allows you to split a text value by a delimiter, whilst the latter applies a LAMBDA to each row and returns an array of the results.
Method A shows the most basic way of using TEXTSPLIT. Each name is split into two columns with a formula for each row. This works fine, but it’s hardly an efficient approach by modern standards.
Method B is interesting, however. BYROW doesn’t seem to like TEXTSPLIT, even though everything in the formula seems right.
Method C is an alternative (although there are others) that uses TEXTBEFORE to extract the first name and TEXTAFTER for the last name. HSTACK then ensures these names spill horizontally. Again, it’s not the most efficient formula, though.
Does anyone know why TEXTSPLIT can’t be used with BYROW in the way shown? I am tempted to call it a glitch, but maybe there’s a good reason.