How to Use SPLIT in Google Sheets
=SPLIT(text, delimiter, [split_by_each], [remove_empty_text]).
What SPLIT does
Data often arrives in one cell: a full name, a list of tags, a date written with dashes. SPLIT breaks that text into pieces at a separator and places each piece in its own cell, one after another across the row. The separator itself is not part of the output.
SPLIT syntax
=SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
text: the text to split, usually a cell reference.delimiter: the character or characters to split at.split_by_each(optional, defaultTRUE): when TRUE, every character in the delimiter is a separate split point. Google's example: a delimiter of "the" splits att,hande. Set it to FALSE to treat the delimiter as one unit.remove_empty_text(optional, defaultTRUE): when TRUE, consecutive delimiters count as one, so no empty cells appear. When FALSE, an empty cell is added between each pair.
A step-by-step example
Here are two pieces of text in cells A1:A3.
| A | |
|---|---|
| 1 | Text |
| 2 | red;green;blue |
| 3 | 2026-10-29 |
To split the first one at each semicolon:
=SPLIT(A2, ";")
This puts red, green and blue in three cells side by side, starting at the formula cell. Here is why:
- Sheets scans
red;green;bluefor the delimiter;. - It cuts the text at each one and drops the semicolons.
- Each piece goes in the next cell to the right, so those cells must be empty.
The same idea works for any separator. For the date in A3, =SPLIT(A3, "-") gives three pieces: 2026, 10 and 29. Splitting on a space, " ", separates words.
Watch out for multi-character delimiters
Because split_by_each is TRUE by default, a delimiter such as ", " is treated as two separate split points, a comma and a space. For text like red, green this still works, because consecutive delimiters count as one. When the delimiter must be matched as a whole, such as "and" between words, add FALSE: =SPLIT(A2, "and", FALSE).
Common SPLIT mistakes
- Blocked output cells. If the cells to the right are not empty, the formula returns an error.
- Forgetting split_by_each. A longer delimiter may cut in more places than you expect.
- Missing quotation marks around the delimiter.
- Expecting text results to stay text. Pieces that look like numbers or dates may be treated as such. Check the cells if the format matters.
Try it yourself
Use the text in A2 and A3 above. Type your formula into the box, starting with =, then press Check.
Exercise 1: Split a list
Write a formula that splits the text in A2 at each semicolon (;).
Exercise 2: Split a date
Write a formula that splits the text in A3 at each hyphen (-).
What to learn next
- TEXTJOIN: combine text from many cells with a separator.
- LEFT, RIGHT and MID: pull part of a text string by position.
- ARRAYFORMULA: run one formula down a whole column.
- Split text into columns: the menu and the formula.
Syntax and rules in this guide were checked against Google's SPLIT help page. See all guides.