Convert Word To Excel

  • Thread starter Thread starter RAH
  • Start date Start date
R

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?
 
RAH said:
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?
Click to expand...

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
 
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
Click to expand...

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
 
Back
Top