What TEXTSPLIT does
TEXTSPLIT breaks one text string into separate cells by using delimiters you define. It is useful when imported data arrives as one long value and you need to turn it into fields without using Text to Columns manually.
Because TEXTSPLIT is a dynamic array function, the result spills automatically into neighboring cells.
Practical examples
Split a full name into separate columns
=TEXTSPLIT(A2," ")
If A2 contains Maya Lopez, Excel returns Maya and Lopez into adjacent cells.
Split one value by both columns and rows
=TEXTSPLIT(A2,",",";")
This is useful when one cell stores comma-separated values inside semicolon-separated records.
Common mistakes and notes
Consecutive delimiters can create empty cells
If the source text contains repeated delimiters, TEXTSPLIT returns blank positions unless you set ignore_empty to TRUE.
Multiple delimiters need an array constant
To split by more than one delimiter, use an array constant such as {"-","/"} rather than trying to stack separate formulas.
Spill space still matters
If the output area is blocked, Excel returns #SPILL!. Clear the destination cells or move the formula.