Level 3REGEXPractice, 3 min
REGEXREPLACE: digits only
The task
Six phone numbers, six formats. In B2, strip everything that isn't a digit from every number with one formula, using
REGEXREPLACE.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | Phone | Digits only |
| 2 | (816) 555-0142 | |
| 3 | 816.555.0199 | |
| 4 | 816-555-0107 | |
| 5 | 816 555 0123 | |
| 6 | 1-913-555-0166 | |
| 7 | 913/555/0188 |