replace dashes

[Guest]

I would like to delete the dashes in a numeric string but keep the numbers intact. ex 0777-3333-5 to 077733335

 

[Kevin Stecyk]

Jose,

Edit | Replace replace dash with nothing.

Be careful: If you only select one cell while enacting this command, XL
will search your entire worksheet. If you want just one cell, choose the
one cell and a blank cell.

Regards,
Kevin

I would like to delete the dashes in a numeric string but keep the numbers

intact. ex 0777-3333-5 to 077733335

 

[Dave R.]

You can also use the substitute function to show the string without "-",
i.e, substitute(a1,"-","")

I would like to delete the dashes in a numeric string but keep the numbers

intact. ex 0777-3333-5 to 077733335