Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2011, 11:43 AM
KIM SOLIS KIM SOLIS is offline How to restore original data format - from a .pdf file to Excel columns Windows XP How to restore original data format - from a .pdf file to Excel columns Office 97
Novice
How to restore original data format - from a .pdf file to Excel columns
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default How to restore original data format - from a .pdf file to Excel columns

Hi experts,

I copied a table (in .pdf) with three-columns from an internet source. I simply highlighted all data (about 200 rows) and pasted it directly in MS Excel expecting to retain the three-column format in Excel. But the result was not as I expected.

The sample result is as shown in the attached file. There is a consistent row-gap for every data (See FROM THIS), though the first three data should have been displayed in a single row only, under the column : School, Code No., Tel. No. (See TO THIS output).

How then should the original three-column format be restored as shown in the attached file? Please note that the blank row-gap is consistent as a break for each data in the table.

Thanks,

Kim
Attached Files
File Type: xls Query105.xls (21.5 KB, 12 views)
Reply With Quote
  #2  
Old 09-18-2011, 10:49 PM
Catalin.B Catalin.B is offline How to restore original data format - from a .pdf file to Excel columns Windows Vista How to restore original data format - from a .pdf file to Excel columns Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

If you don't have a professional tool like Abby fine reader, you can try this online tool, which will create an excel workbook; every table from uploaded PDF file is saved in a new worksheet, with almost no errors; then you can copy this table in your work (you will receive an email with your converted file)
http://www.pdftoexcelonline.com/
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create microsoft Excel 2007 and 2010 File in .xlsx format ipacesetters Excel 1 12-16-2019 05:13 PM
how to create two columns based on a certain criterior from the original two column? where_pc Excel 3 06-13-2011 10:39 AM
How to restore original data format - from a .pdf file to Excel columns HELP! How do I restore a pst file? scubafanatic Outlook 1 10-22-2010 12:19 PM
Excel file lost data how to recover it zillah Excel 1 02-10-2010 08:36 PM
How to restore original data format - from a .pdf file to Excel columns Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft