Convert Word To Excel

[RAH]

I have scanned a document using OCR into Word 2007 with the RTF
format. I have three columns of data. I am trying to copy these
three columns to Excel 2007, but having a problem.

When I copy the data in Word, then paste to Excel, all the column data
goes to rows. If I copy the rows in Excel, and use the
paste/transpose command, the date is still in rows. How can I get the
columns in Word to stay as columns in Excel?

 

[bookplatemuseum.com]

I have scanned a document using OCR into Word 2007 with the RTF
format. I have three columns of data. I am trying to copy these
three columns to Excel 2007, but having a problem.

When I copy the data in Word, then paste to Excel, all the column data
goes to rows. If I copy the rows in Excel, and use the
paste/transpose command, the date is still in rows. How can I get the
columns in Word to stay as columns in Excel?

If your text is seperated by blank spaces the convert those into tabs.
The convert the text rows into tables.
Copy table over to excel.
I often use this method.

Any other ways of skinning this cat?

Phil

 

[RAH]

If your text is seperated by blank spaces the convert those into tabs.
The convert the text rows into tables.
Copy table over to excel.
I often use this method.

Any other ways of skinning this cat?

Phil

Thanks. I tried it last night and came up with jibberish. I need to
learn more about adding tabs to existing data. Every time I tried to
add a tab, it moved data around on the page. I'll try it again today.

Dick