Excel TEXTSPLIT function⚡ Split text into cells
The TEXTSPLIT function: Split text into cells. Split names and places typed together. This page shows the syntax, a worked example with its result and how the formula reads.
What does TEXTSPLIT do?
Split text into cells. Split names and places typed together
TEXTSPLIT syntax
=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
Arguments in square brackets [ ] are optional · argument names follow Microsoft's documentation
TEXTSPLIT example with the result
=********
👑 Ready-to-use example formula for VIP supporters only · Become VIP
Formula in cell C2 Yellow cells = result
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Combined | Split | |||
| 2 | Somchai,Jaidee,Bangkok | Somchai | Jaidee | Bangkok |
How it reads: Cuts the text at each comma into separate cells
Frequently asked questions about TEXTSPLIT
What does TEXTSPLIT do?
Split text into cells. Split names and places typed together
What does the TEXTSPLIT example return?
The example formula in cell C2 spills its results into several cells starting at C2, as shown in the example table.
Which Excel versions have TEXTSPLIT?
Excel for Microsoft 365 and Excel 2024 or later, according to Microsoft's function list. Older versions show #NAME?.
🕸️ More dynamic arrays formulas and related ones
Source: support.microsoft.com
Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning