I have a column of SSNs in a text format and would like to know it ther
is a macro that starts at the top and removes the dashes between th
numbers... one cell at a time... and stops after it removes the las
one

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

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/

Thanks so much your assistance... your solution was so simple I now fee
foolish for even putting the request out there... after all, you
solution did not require a macro

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