SPLIT

Splits text across several cells at a chosen delimiter.

SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

SPLIT is the inverse of TEXTJOIN and the fastest way to break a full name, an address or a pasted CSV line into columns.

Arguments

Argument	Required	What it does
`text`	Yes	The text to split.
`delimiter`	Yes	The character or characters to split on.
`split_by_each`	Optional	TRUE (default) splits on each character in the delimiter separately.
`remove_empty_text`	Optional	TRUE (default) drops empty results between consecutive delimiters.

Full name
Ana Ruiz
Ben Okafor

=SPLIT(A2, " ")

Returns Ana | Ruiz.

First and last name land in two separate cells.

split_by_each defaults to TRUE, so a delimiter of ", " splits on commas AND spaces. Pass FALSE to treat it as one unit.
The result spills sideways and overwrites nothing — but it will hit #REF! if the cells to the right are occupied.
Splitting a date or number turns the pieces into text.