Remove Hyphens using Substitute

August 14th, 2004 | Categories: Data | Tags:

A common question is how to remove hyphens from text. The trick is to Substitute the hyphen with nothing.

For this example, let’s assume cell A1 has text with hyphens in it. Here’s how to remove them

1. In a blank helper cell type =SUBSTITUTE(
2. Click on the cell you would like to substitute characters in or A1 (this automatically fills your formula)
3. Type, (comma)
4. Type “-”
5. Type, (comma)
6. Type “” and hit enter

Your end result in your helper cell should look like this:


  1. December 16th, 2013 at 18:24
    Reply | Quote | #1

    Thanks for sharing your thoughts about Smashbox. Regards