Formula to Delete hyphens

[mcorydon]

This is probably the easiest question you will answer today but I'm trying to create a formula that turns 123-456-7890 into 1234567890. Ideally this is a formula that i can drag down my entire spread sheet to change a few hunder fax number.

Thanks!

 

[dispelthemyth]

=substitute(b1,"-","")

 

[Rick Rothstein]

This is probably the easiest question you will answer today but I'm trying to create a formula that turns 123-456-7890 into 1234567890. Ideally this is a formula that i can drag down my entire spread sheet to change a few hunder fax number.

Give this a try...

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

 

[Snakehips]

mcroydon,

Eg original in A1 this formula in B1....

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

Hope that helps.

 

[Audiman]

Just a suggestion but I think people are making this more complicated than it needs to be.
Why not just select the Column and press CTRL+H
Find Replace - with nothing.

 

[Rick Rothstein]

Just a suggestion but I think people are making this more complicated than it needs to be.
Why not just select the Column and press CTRL+H
Find Replace - with nothing.

The OP said "I'm trying to create a formula that ... i can drag down my entire spread sheet"... my thought was he wanted to preserve the original data and that the dashless numbers were needed for some other formula's or program's use.

 

[Audiman]

Sorry I wasn't trying to imply anything. Just sometimes people over think stuff. I have actually done the Substitute to delete all the * in a sheet. When I could have just used CTRL+H. Just over thought the process. I had believed even the OP over thought it.

 

[dispelthemyth]

Its always worth suggesting, so the OP can decide if they want that or not But​ using Substitute is not over complicating it, its just what was asked for

Sorry I wasn't trying to imply anything. Just sometimes people over think stuff. I have actually done the Substitute to delete all the * in a sheet. When I could have just used CTRL+H. Just over thought the process. I had believed even the OP over thought it.