What is SPLIT in Google Sheets?
SPLIT divides one text cell into multiple cells spilled across columns using a delimiter such as comma, space, or custom string. It is the formula version of Text to columns for live data like tags, full names, or combined codes.
When to use it
Use SPLIT when a single cell holds delimited values you need in separate columns for FILTER, COUNTIF, or mail merge.
When to skip it
Skip SPLIT when delimiters also appear inside quoted fields or when REGEXEXTRACT gives more reliable parsing.
How it works
-
1
Reference the text cell or range as the first argument.
-
2
Pass the delimiter string, or TRUE for split-by-each-character mode per docs.
-
3
Leave empty columns to the right for the spill width.
-
4
Combine with INDEX to pick one segment after SPLIT.
-
5
TRIM each piece with TRIM on INDEX if spaces trail tokens.
-
6
Use FLATTEN(UNIQUE(SPLIT(...))) to build tag lists from multi-value cells.
Examples in Google Sheets
First and last name
=SPLIT(A2, " ") separates first and last when a single name cell holds both.
Comma tags
=SPLIT(B2, ",") spills three tag columns from one comma-separated cell.
URL path parts
=SPLIT(C2, "/") breaks a path into segments for routing logic.
Better Sheets resources
Common mistakes
-
Delimiter inside data splitting names like O Brien wrong.
-
Not enough blank columns so spill hits existing formulas.
-
Assuming fixed column count when some cells have extra delimiters.
-
Using SPLIT on numbers without TEXT first.
-
Forgetting TRIM on pieces with leading spaces after comma-space joins.
Frequently asked questions
- SPLIT vs Text to columns?
- SPLIT is formula-driven and updates live. Menu action is one-time static.
- SPLIT each character?
- Use the split-by-each-character option documented for SPLIT.
- Pick one piece after SPLIT?
- INDEX(SPLIT(...), n) returns the nth segment.
- SPLIT down a column?
- SPLIT spills horizontally per row. One formula row per source cell.
- Multiple delimiters?
- One delimiter per SPLIT. Chain or use REGEX for complex cases.
- SPLIT and ARRAYFORMULA?
- Often unnecessary; SPLIT on a vertical range spills per row.
- Empty trailing splits?
- Trailing delimiters may create blank trailing cells.
Related Tutorials
Watch how SPLIT works
Count How Many Subscribers In a Company by BetterSheets.co
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
Related blog posts
Guides that explain SPLIT in more depth.
Spreadsheets Explained over 5 Levels of Difficulty
Master Google Sheets from simple text input to complex operations with our FREE tutorials, templates, and tools! Unleash the full power of spreadsheets now!
Read post →Spreadsheets Explained! 5 Levels of Difficulty: From Basic Text Input to Google Apps Script
Five increasingly difficult ways of explaining spreadsheets in Google Sheets: The basics of Google Sheets text Menu items in Google Sheets Math inside Google Sheets Using Formulas in Google Sheets Apps Script in Google Sheets
Read post →Getting Started in Google Sheets Spreadsheet Management
Users can also customize the appearance of their spreadsheets with different fonts, colors, and themes.
Read post →Related terms
TEXTJOIN
TEXTJOIN merges many text values into one string with a delimiter between them. The ignore_empty argument skips blanks so you do not get double commas. It builds display labels, CSV-like rows, and summary lines from wide tables.
Read guide →REGEXEXTRACT
REGEXEXTRACT returns the portion of text that matches a regular expression, often using capture groups to pull IDs, domains, or codes from longer strings. It replaces manual LEFT/RIGHT/MID chains when patterns repeat.
Read guide →UNIQUE
UNIQUE extracts a deduplicated list from a column or table. Optional arguments control whether duplicates appear by row, by column, or with occurrence counts. It powers dropdown source lists, category tabs, and data cleanup without manual copy-paste.
Read guide →FLATTEN
FLATTEN converts a two-dimensional range into a single column, reading across rows then down. It is useful after SPLIT or when you need every value from a block in one list for UNIQUE, COUNTIF, or mail merge prep.
Read guide →Done reading about SPLIT?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.