TEXTSPLIT
TextMicrosoft 365Split text into a spilled array by a column and/or row delimiter.
Syntax
TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
Arguments
- text
- The string to split.
- col_delimiter
- Delimiter that splits into columns, e.g. ",".
- row_delimiteroptional
- Delimiter that splits into rows, e.g. a line break.
- ignore_emptyoptional
- TRUE collapses consecutive delimiters.
- pad_withoptional
- Value for missing cells in a ragged split.
Examples
=TEXTSPLIT("a,b,c", ",")
→ a | b | c (spills across 3 cells)
Related functions
More Text functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.