 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Convert Word To Excel
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? > 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 [quoted text clipped - 4 lines] > 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 -- Personalize your book library though bookplates. Check out http://www.bookplatemuseum.com Perhaps you could save the RTF as a TXT file, and open directly by Excel, and the wizard would help place the data in correct cells.... Beege >> 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 [quoted text clipped - 13 lines] > > Phil >> 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 [quoted text clipped - 13 lines] > >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 >>> 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 [quoted text clipped - 19 lines] > >Dick Most text editors have "change tabs to spaces" and "change spaces to tabs" buttons. ...Jim Thompson | James E.Thompson, P.E. | mens | | Analog Innovations, Inc. | et | | Analog/Mixed-Signal ASIC's and Discrete Systems | manus | | Phoenix, Arizona 85048 Skype: "skypeanalog" | | | Voice:(480)460-2350 Fax: Available upon request | Brass Rat | | E-mail Icon at http://www.analog-innovations.com | 1962 | America: Land of the Free, Because of the Brave |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.