Excel 365 + Google Sheets · TEXTSPLIT
Split text into columns with a formula
Splits a text into several cells using the separator you choose.
The formula
=TEXTSPLIT(A2, " ")What each part means
A2The text" "Split at each space
Example
| A | B | C | |
|---|---|---|---|
| 1 | Full name | First | Last |
| 2 | Laura Gómez | ||
| 3 | João Silva | ||
| 4 | Priya Shah | ||
| 5 | Tom Baker |
| A | B | C | |
|---|---|---|---|
| 1 | Full name | First | Last |
| 2 | Laura Gómez | Laura | Gómez |
| 3 | João Silva | João | Silva |
| 4 | Priya Shah | Priya | Shah |
| 5 | Tom Baker | Tom | Baker |
Step by step
- Click cell B2.
- Type the formula:
=TEXTSPLIT(A2, " ") - Press Enter.
- The results fill the cells below by themselves (it’s a dynamic array formula). Don’t type anything in them.
Where it works
- Excel 365 and Excel 2021 or newer
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English TEXTSPLIT
- Español DIVIDIRTEXTO
- Português DIVIDIRTEXTO