Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SUBSTITUTE. SUBSTITUTE(text, old, new) swaps every copy of old for new. An optional fourth argument, instance, swaps only that one copy: 1 means just the first. SUBSTITUTE is case-sensitive, and a new of "" deletes the old text.
=SUBSTITUTE("Q3 / West / 2025"," / ","-") gives Q3-West-2025The call-centre dialer only accepts phone numbers written with dashes, like 555-643-0064, but the CRM import uses dots. You asked the AI assistant to convert them.
AI assistant: “Done! C2:C9 swaps the dots for dashes, so the numbers are ready for the dialer.”
Check the AI’s formulas in C2:C9. Fix them so every dot in the phone number in column B becomes a dash.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Contact | Phone (import) | Phone (dialer) | |||||
| 2 | Maria Hart | 555.643.0064 | 555-643.0064AI | |||||
| 3 | Kevin Hart | 555.697.5360 | 555-697.5360AI | |||||
| 4 | Chris Patel | 555.538.7574 | 555-538.7574AI | |||||
| 5 | Peter Hart | 555.749.1680 | 555-749.1680AI | |||||
| 6 | Rachel Price | 555.556.0303 | 555-556.0303AI | |||||
| 7 | Leo Fox | 555.554.8960 | 555-554.8960AI | |||||
| 8 | David Walsh | 555.956.1029 | 555-956.1029AI | |||||
| 9 | Brian Reed | 555.703.1754 | 555-703.1754AI | |||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe