Text·Lesson 40 of 62Pro
How to use SUBSTITUTE in Google Sheets
Replace text
How SUBSTITUTE works
SUBSTITUTE replaces every copy of some text with something else.
SUBSTITUTE(text, find, replace with)
Example on this data
=SUBSTITUTE(B2,"acme","example")→maria.lopez@example.com
Swaps the company name in the email.
What you’ll do
You’ll swap every dash in a SKU for a space. Replacing text is useful for cleaning data or reformatting codes.
Try it
Type =SUBSTITUTE(B2,"acme","example") 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 SUBSTITUTE 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, show the SKU in C2 with every dash replaced by a space.
One payment, no subscription.