Remove - from tel numbers

[patman.nyc]

I have a column of tel numbers with the dash, can you direct me as to how to remove it, so there is just the 7 digits in the field?

 

[VoG]

Try like this

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

 

[rpaulson]

if the dash is always in the 4th spot then try.
=MID(A1,1,3)&MID(A1,5,4)

someone beat me to it.

 

[patman.nyc]

Thanks all. But how do I do it for a whole column of about a thousand numbers?

 

[rpaulson]

Edit Fill Down

 

[Armando Montes]

Try find and replace, Control+H.
Find what: -
Replace with: leave blank
Clic replace all