replace dashes

J

jose

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

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

jose said:
I would like to delete the dashes in a numeric string but keep the numbers
Click to expand...
intact. ex 0777-3333-5 to 077733335
 
D

Dave R.

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


jose said:
I would like to delete the dashes in a numeric string but keep the numbers
Click to expand...
intact. ex 0777-3333-5 to 077733335
 
Top