Removing dashes from a column

[Tommy Kramer 9]

I have a 500+ cell column with 13 digit numbers that look like this.
18-118-22-33-0011 I would like to remove all of the dashes from every cell
in the column but I can't figure out how.

 

[David Biddulph]

=substitute(A2,"-","") and copy down.

 

[Fred Smith]

What do you want to do with the (<=99999)? Then we can answer your "Now
what" question.

Regads,
Fred.

 

[Gord Dibben]

I think OP is wondering how it got there as much as how to deal with it.

I would also like to know.

(<=99999) was not part of the original data.


Gord Dibben MS Excel MVP