Manually create an excel readable table

[zoltain]

I have pdf's that I need to get into excel. I've tried 1000 different ways of converting into many different formats/file types but inevitably something gets screwed up. I am able to get the PDF into a rtf & Doc format where all the data still is organized into a table "looking" format (ie all the columns are lined up). When I try and copy it into excel, some cells get merged, others separate into multiple cells and generally I am left will too many problems to fix manually. I've tried to import the data but it turns into gibberish (I think because its not ANSI).

Ideally I would like to import the data into excel (or use an outside program first) and use the fixed width function but excel can't read the files when I do this.

Hopefully I have made some sense. Any help would be greatly appreciated.

[shg]

In Acrobat, you have the option of copying data as a table.

[zoltain]

Thanks for the response,

I have tried Acrobat and run into the same problem as I do from going from word or OO. there are multiple errors in the location of the data.