Tim has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course
Transferring Data from unlocked pdf to excel
Is it possible to transfer a table from an unlocked pdf file to excel and keep the right numbers in the right boxes?
At the moment when I try copying and pasting it, the data goes into excel with the correct number of rows but with all the information in a single column.
RE: Transferring Data from unlocked pdf to excel
Dear Tim
When you copy and paste or import text data in to MS Excel it is based on the delimiters. This simply means how your data has been separated e.g. space, tab, comma , etc..
Normally if you have your data separated with a space bar, which I assume it is in pdf, then it will put all the data in one cell. Excel has been programmed to treat a tab as a new column and Enter key as a new row.
The easiest thing that I can suggest you is that before you copy and paste edit the pdf file by placing tab keys wherever you want the data to be in a new column and press Enter key where you want it to be in a new line.
You can simply copy and paste the text and it should work.
See if this helps. If not please reply to this and I
RE: Transferring Data from unlocked pdf to excel
I can see how that would work for a smaller document but the spreadsheet in the pdf document has around 20 columns and 50 rows (and many of the individual cells are left with a dash only to indicate no number) so that is an extremely labour intensive way of doing things!
Also I only have adobe reader so I have to copy the spreadsheet into word, notebook or excel before I can edit it at all.
Tim
RE: Transferring Data from unlocked pdf to excel
Ive tried replacing all the spaces with commas, saving it as a text document and then opening it back up into excel but this hasnt helped either!!
Tim
RE: Transferring Data from unlocked pdf to excel
Dear Tim
If I read correctly you said that the data in pdf is unlocked and I assume that you can easily copy and paste it in Word.
I know that if you have table in MS Word it can easily be copied and pasted in Excel and each box of the table easily fits into each cell of the worksheet. If you
When you copy and paste the table and if MS Word doesn
