Text·Lesson 41 of 62ProSheets only
How to use SPLIT in Google Sheets
Split text into columns
How SPLIT works
SPLIT breaks text into separate cells wherever a delimiter appears. It's Google Sheets only.
SPLIT(text, delimiter)
Example on this data
=SPLIT(B3,"@")→jchen · northwind.io
Splits the email into name and domain.
What you’ll do
You’ll split a SKU into its separate parts, one per column. Splitting text saves you from cutting and pasting pieces by hand.
Try it
Type =SPLIT(B3,"@") into G2 and press Enter. Watch what the sheet does.
The result will appear in G2.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Full name | SKU | Note | ||||
| 2 | maria lopez | maria.lopez@acme.com | WID-2041-BLU | Call back 555-0142 | |||
| 3 | james chen | jchen@northwind.io | GAD-1180-RED | Sent invoice | |||
| 4 | Priya Shah | priya@shahdesign.co | WID-3307-GRN | Call back 555-0199 | |||
| 5 | tom o'neil | tom.oneil@acme.com | BOX-0042-BLU | Left voicemail | |||
| 6 | Lena Park | lena.park@globex.com | GAD-2215-BLK | Call back 555-0107 | |||
| 7 | sam reed | sreed@northwind.io | WID-0918-RED | Meeting Tue |
Ctrl+/ shows the shortcuts
Drill locked
Unlock the other 44 lessons for $49.99
You’ve seen how SPLIT works. Pro lets you write it yourself on real data and get checked instantly, with practice sets and section reviews for every lesson.
Your drill
In G2, split the SKU in C2 into its three parts, one per column.
One payment, no subscription.