A Macro to Edit Cell Content
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 |
A Macro to Edit Cell Content
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/ |
A Macro to Edit Cell Content
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 |
All times are GMT +1. The time now is 04:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com