how to remove dashes

[chiuinggum]

I have a list of 500 part number with dashes in between. Example 1234-56-789.
How do able to remove the dashes to make it 123456789?

 

[JE McGimpsey]

One way:

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

the -- will convert the text string into ann actual number. If you want
to leave your "number" as text, omit them.

[email protected]

 

[RichardSchollar]

I have a list of 500 part number with dashes in between. Example 1234-56-789.
How do able to remove the dashes to make it 123456789?

You could do them en masse by using Find/Replace ie select the entire
column and press Ctrl+H and in Find What: - and in Replce With:
(leave this blank).

Hope this helps!

Richard