SUBSTITUTE
Replaces specific text with other text.
How it’s written
SUBSTITUTE(text, old, new)Example
| A | |
|---|---|
| 1 | Phone |
| 2 | 555-0100 |
=SUBSTITUTE(A2,"-","")Result: 5550100
Replaces the dash with nothing, which removes it.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
It matches capitals exactly.
Practice it properly
Replacing and formatting text gives you real tasks, with your formulas tested on data you haven’t seen.