How to Use SPLIT in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 6 min read · includes 2 free exercises

In short: SPLIT divides text around a character you choose and puts each piece in its own cell in a row. The formula is =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])

A step-by-step example

Here are two pieces of text in cells A1:A3.

A
1Text
2red;green;blue
32026-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:

  1. Sheets scans red;green;blue for the delimiter ;.
  2. It cuts the text at each one and drops the semicolons.
  3. 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

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 (;).

Hint: the delimiter is ";" in quotation marks.

Exercise 2: Split a date

Write a formula that splits the text in A3 at each hyphen (-).

Hint: SPLIT(A3, "-").

What to learn next

Syntax and rules in this guide were checked against Google's SPLIT help page. See all guides.