Exercises / Cleaning text · 9 of 13
Strip dashes and spaces from phone numbers
SUBSTITUTE(text, old, new) replaces every occurrence of old with new. Replace with "" to delete. Nest two SUBSTITUTEs to remove two different characters.
Your taskIn B2, use SUBSTITUTE to remove both the dashes and the spaces from the phone number in A2. It will be copied down to B7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B |
|---|---|---|
| 1 | Phone | Digits |
| 2 | 555-201-3344 | |
| 3 | 555 019 2281 | |
| 4 | 555-330 7712 | |
| 5 | 555 - 412 - 0098 | |
| 6 | 5557719920 | |
| 7 | 555-880-1234 |