Text
TEXTSPLIT
Splits a text across cells.
Syntax
TEXTSPLIT(text, col_delimiter, [row_delimiter])Example: =TEXTSPLIT(A2,", ")
Available in: Excel 2024, Microsoft 365
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in D2: =TEXTSPLIT(A6,", ")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Text | Other | Result | |||
| 2 | Alice Johnson | alice johnson | iced coffee | tea | sugar | |
| 3 | alice@shop.com | ALICE@shop.com | ||||
| 4 | extra spaces | |||||
| 5 | SKU-2026-0415 | |||||
| 6 | iced coffee, tea, sugar | |||||
| 7 | Order 417 shipped |
Result in D2: iced coffee