Table copied from PDF goes into 1 Column

W

Webcentre

Hi, Im pulling me hair out here trying to get this to work.

Problem is I have information in a PDF file in the form of a table.
Unfortunatly when i copy it from PDF to Excel, it goes into 1 column, rather
than splitting the text up into the 7 columns it is in in the PDF. Now I
cant seem to work Acrobat 8, so does anyone know if you can create columns in
text in Excel.

E.g. 07917121592 12.50 0.00 21.780 0.00 0.00 0.00 0.00 34.280

Every space you see above should be in a separate column but at the mo they
arent.

Any Help would be much appreciated

Thanks

Mat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loosing transparency effect of Master Page graphic when Saving Publisher files as .pdf 0
Format column widths from one table to a separate table on same page 1
Insert Index into a Table 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Data Entry Confusion 1
Sorting in Pivot table 0
Need to import a table done in PDF into Excel 4
Convert text invoice into a table- please help! 8

Top