|
Removed digit from excel spreed sheet
and FIND then combine -- Don Guillett SalesAid Software "Lillian" wrote in message ... I have one big excel spreed sheet it look like this ColumnA 947865:130002- 947866:130002- 947867:ERROR I would like move 7865 in Column B and move 130002 or ERROR to column C I mean only take 4,5,6,7 digit to ColumnB and take 9,10,11,12,13,14 to ColumnC How do you write the macro for this? Thank you so much Lillian |
| All times are GMT +1. The time now is 02:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com