Before trying anything with VBA, maybe the DATAEXTRACTION command already does what you want.
Hi,
>> but all the extracted text are in one column
It's hard to show something when nobody here knows what you exactly need.
It's also difficult when we don't know where you are with your code now and where exactly you need help. E.g. can't you select text objects or do you have a drawing with different objects representing characters (like mtext, text, leader objects, block-attributes, .... or do you have problems accessing Excel via VBA? We even don't know if you are working with AutoCAD VBA or Excel VBA.
I guess a bit more description + showing the code you are currently working on will help to get more feedback.
- alfred -