replace dashes

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to clear contents of certain cells 4
Word Dashed line formatting 0
zeros show as dashes in spreadsheet, want to show 0. 2
Convert 2
Eliminating the dashes 3
VLOOKUP Returns #NA For text/numbers with a dash - 13
remove a dash from part numbers 3
Problem With Text & number format 1

Top