Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
TEXTSPLIT
TEXTSPLIT divides a text string across columns, rows, or both dimensions using one or more delimiter characters, returning a dynamic spill array of the resulting pieces. Use it to parse CSV-style data, split full names into components, or break multi-value cells apart without complex nested MID/FIND formulas.
Excel
=TEXTSPLIT(A2,",")Google Sheets
=TEXTSPLIT(A2,",")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Reference the cell containing the text you want to split.
- 2Provide the column delimiter as the second argument (and optionally a row delimiter as the third).
- 3Enter =TEXTSPLIT(text, col_delimiter) and let the result spill across adjacent columns automatically.
Need a version for your data?
Try: “Split a comma-separated list of tags in one cell into separate columns”