put your cursor on the title bar for the column ie: C
editreplace - with nothing voila

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tommy Kramer 9" <Tommy Kramer wrote in message
...
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.