I have a PDF file that contains tables of data that I want to analyze in excel. I tried saving the pdf as an excel file but when I did some sections of the table import as one large cell instead of individual cells for each value. I have attached a sample excel sheets that I saved from PDF. I was not able to upload a PDF to this site so I can't provide the original PDF as an example. If someone knows how to do this where each value is in a cell I would really appreciate the help.
1. have you tried copy pasting into excel
2. have you tried an on line converter like zamzar
http://www.zamzar.com/
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I tried both of those with no luck. Thank you for the suggestions. I welcome any others.
post the pdf then we can have a play with it
I doubt very much if you can get a usable workbook from a pdf.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
The PDF is attached. The table is on page 74-84. I tried deleting pages out of the PDF to leave just the table for you but when I did that this site would not allow the upload. Thank you for your help.
Do a simple copy and paste (might have to do one page at a time) in Excel. All your data will be captured in a single column.
You could then use data--Text to columns--Delimited by --Space
I did a sample and it works.
Life's a spreadsheet, Excel!
Say thanks, Click *
you can save the pdf as text
then try opening it with excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks