How to get pdf data into excel?

[buzzing]

Hi,
I want to use data that I recieve in pdf format, in an excel spread sheet.

Its 6 columns of figures, and i want to put each column in a seperate column in excel, one number in each cell.

I am entering the figures manually at the moment.

Is there a way to copy and paste the figures in, instead?

buzzing

 

[Norie]

Why don't you just try copying and pasting, and then going to Data>Text to Columns...?

 

[JeffK627]

What version of Acrobat are you running? If all you have is Adobe Reader, then I don't think you can copy and paste from a PDF. If you have the full version, then you can - Adobe Acrobat 6.0 allows you to basically treat a PDF as if it were a Word document.

One thing - if the PDF is the result of scanning a printed document into Acrobat, then it is no longer text but an image - you will not be able to cut and paste no matter what version of Acrobat you have.

 

[buzzing]

Thank,s for that, I'll give it a go.

 

[Norie]

JeffK627

I've only got Reader and I'm able to copy and paste no problem.

Mind you the results are pretty poor.

 

[JeffK627]

JeffK627

I've only got Reader and I'm able to copy and paste no problem.

Mind you the results are pretty poor.

Really? I didn't think that worked. I'll have to give it a try...