I have a column of strings like this:+---------+| a bb    || ccc d   || ee ffff |+---------+(exactly one space in each string), which I'd like to split by the space into two columns: +-----+------+| a   | bb   || ccc | d    || ee  | ffff |+-----+------+This can be done by putting B1 =split(A1, ) and dragging down the column. But I'm looking for an arrayformula version of this. Unsuccessful attempt: the formula  =arrayformula(split(A1:A3, )) throws #VALUE error: Function SPLIT parameter 1 value should be non-empty.
Split a column of strings with a single formula returning an array
google spreadsheets
Google introduced a built-in tool for this purpose: Split text to columns. Select a range to split, keeping in mind the separator menu will be at the bottom of this range (this is not very convenient for splitting a very tall column). Use Split column to text from the menuSelect a separator. Warning: the cells to the right of the column you are splitting may be overwritten when the column splits. 