Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
SPLIT
SPLIT divides a text string at every occurrence of a specified delimiter and spills the resulting segments into adjacent cells horizontally. It is a Google Sheets-native function commonly used to separate comma-delimited values, full names, or structured codes into individual columns.
Excel
=TRIM(MID(SUBSTITUTE(A2,",",REPT(" ",100)),1,100))Google Sheets
=SPLIT(A2,",")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Tags | Tag 1 |
| red,blue,green | red |
| cats,dogs | cats |
| a,b,c,d | a |
| one,two | one |
=TRIM(MID(SUBSTITUTE(A2,",",REPT(" ",100)),1,100))→red
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1In Google Sheets, select the destination cell where the first segment should appear — each subsequent segment spills one column to the right.
- 2Enter =SPLIT(A2,",") to break text in A2 at every comma, placing each piece in a separate column.
- 3Use the optional split_by_each argument (FALSE) to treat the delimiter as a whole string rather than splitting on each individual character.