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:

=SUBSTITUTE(A1,”-”,”")