Text·Lesson 37 of 62Pro
How to use MID in Google Sheets
Take characters from the middle
How MID works
MID returns characters from the middle of text, starting at a position you choose.
MID(text, start, how many)
Example on this data
=MID(B3,1,5)→jchen
The first 5 characters of the email in row 3.
What you’ll do
You’ll pull the number out of the middle of a SKU. Grabbing characters from a set position helps when codes follow a fixed pattern.
Try it
Type =MID(B3,1,5) 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 MID 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, pull out the 4-digit number in the SKU in C2.
One payment, no subscription.