All functions / Dynamic arrays

TEXTSPLIT

Splits text into separate cells at a delimiter. The result spills.

Syntax

=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty])

Arguments

• text: The text (or a cell containing it).
• col_delimiter: Split into columns at this text.
• row_delimiter (optional): Split into rows at this text.
• ignore_empty (optional): TRUE to skip empty pieces.

Example

=TEXTSPLIT("red,green,blue", ",") → Three cells across