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