98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.training.course.london - Transferring Data from unlocked pdf to excel | Excel forum
excel.training.course.london - Transferring Data from unlocked pdf to excel | Excel forum
Resolved · Low Priority · Version Standard
Mon 14 Jan 2008, 11:44Delegate Tim said...
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.
Mon 14 Jan 2008, 16:09Trainer Rajeev said...
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
Mon 14 Jan 2008, 16:43Delegate Tim said...
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
Wed 16 Jan 2008, 10:05Delegate Tim said...
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
Wed 16 Jan 2008, 13:02Trainer Rajeev said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shared Conditional FormattingIn a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones. |
