A Macro to Edit Cell Content

[jer101]

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

 

[Tom Ogilvy]

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.

 

[jer101]

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