A Macro to Edit Cell Content

J

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
 
T

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.
 
J

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
 
Top