excel.training.course.london - transferring data unlocked pdf

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version Standard

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


 

Excel tip:

Shared Conditional Formatting

In 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.

View all Excel hints and tips


Server loaded in 0.08 secs.