Hi,

I would like to know if it's possible to extract data from word and arrange it in excel?
I have many words document with data in same line, example,

Word:
Line 12 Eric
Line 19 $ 500
Line 20 $ 400
Line 21 $ 300
Line 22 $ 500

I would like to extract that data to excel for each line in word goes to each column in excel

Excel:
Line 12 Line 19 Line 20 Line 21 Line 22
Eric 500$ 400$ 300$ 500$
Cell A1 Cell B1 Cell C1 Cell D1 Cell E1
and then loop for next word file and do the same.

It will take too long to copy and paste from word to excel for about 80 files. Any help will be appreciated.

Here is 2 samples of the word file.

Sample 1.docSample 2.doc

Thanks.