Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Canjun Bob,
Suprisingly, after I rephrased the question on USENET I managed yesterday (it was frankly Public Holiday here in South Africa) to come-up with the solution toward your problem. To take you through process, here are the instructions: Firstly, After opening your adobe file go to the "Tool Menu" and under "Select & Zoom" you select the "Select tool" there after highlight all your content in the Adobe file that has table. Thereafter paste on the first "Cell" on the left hand corner of Excel. Unfortunately the data in Excel will appear jumble and disorganized. Thereafter, for all the words/title/headings insert a semicolon (;) in front of them (but not on each words). And then select the first column (being A) in excel (and not all columns) and go to "Data Menu" and seclect undernearth "Text to Colum" submenu" and select "delimit" thereafter press next and select ONLY "Semicolon" sections and press finished. You will noticed that the words/title/headings have each been allocated on the first column. For number or figures, select the second column (being B) reapeat the same process in excel but under the Text to Colum" submenu use the "space" option (and not the Semicolon option) under the delimit section. You will notice that the data (figures/number) will start arranging themselves in an orderly form. But more importantly make sure that your (figures/number) don't have spaces in between or else the whole data will apprear in one column (for example 1 000 000.00 should be expressed as 1,000,000.00 and not like the former) I hope this answer your question. But should you encouter problems, you can contact me at: +27 72 043 6779 Fanie "cajun-bob" wrote: Greetings all, I am working on a project involving several dozen PDF files containing some data in tables. I would like to be able to convert those PDF tables to Excel so that I can work with the data in Excel spreadsheets. The PDF files are located on several research websites that all happen to use PDF. I have Windows Vista Ultimate and I have a DELL Inspiron 9400. Presently I am using Adobe Reader 8.1 to read the PDF files. The simpler the solution, the better - as I am not as computer literate as I should be. Thanks. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert Pivot table back to Data Table | Excel Discussion (Misc queries) | |||
convert Pivot table back to Data table | Excel Discussion (Misc queries) | |||
Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
Pivot Table - How Do I Convert Data? | Excel Worksheet Functions | |||
Convert data from a table to a chart? | Charts and Charting in Excel |