Skip to content
FormulaCraft

SUBSTITUTE

SUBSTITUTE replaces every occurrence of a piece of text with another. Use it to strip dashes from phone numbers, swap words, or clean up formatting.

Excel
=SUBSTITUTE(A2, "-", "")
Google Sheets
=SUBSTITUTE(A2, "-", "")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the source text.
  2. 2"-" is the text to find.
  3. 3"" (empty) replaces it with nothing, removing every dash.

Need a version for your data?

Try: “Remove all dashes from the phone number in A2”

Related

TEXTJOINLEFT / RIGHT / MIDTRIM

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: