TEXTSPLIT Generator
Split one cell of text into separate columns using a delimiter you choose.
TEXTSPLIT
Split one cell of text into separate columns using a delimiter you choose.
The cell holding the combined text you want to break apart.
The character or text that separates the pieces, in quotes. Use " " for spaces or "|" for pipes.
=TEXTSPLIT(A2, ",")Worked Example
A2 contains Ada,Lovelace,London and you want each part in its own column.
=TEXTSPLIT(A2, ",")Returns: Spills three cells across the row: Ada, Lovelace, and London.
Checks Before You Paste
- •TEXTSPLIT spills its results across the cells to the right, so anything already sitting there causes a #SPILL! error. Clear the neighbouring cells rather than trying to fix the formula.
- •Values often keep a leading space when the source used a comma and a space. Either set the delimiter to ", " or wrap the whole thing as =TRIM(TEXTSPLIT(A2, ",")), which trims every spilled value at once.
- •Split on more than one delimiter by passing an array constant, for example =TEXTSPLIT(A2, {",",";"}). The full signature is TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]), and text delimiters are matched case sensitively unless you set the fifth argument, match_mode, to 1.