|
Removed digit from excel spreed sheet
Have a look in the help index for MID
-- 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 10:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com