select the range of cells

do Edit=Replace
Replace what: -

Replace with: leave blank

if you need a macro, turn on the macro recorder while doing the above
manually.

--
Regards,
Tom Ogilvy

"jer101 " wrote in message
...
I have a column of SSNs in a text format and would like to know it there
is a macro that starts at the top and removes the dashes between the
numbers... one cell at a time... and stops after it removes the last
one?


---
Message posted from http://www.ExcelForum.com/