View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
KC Rippstein hotmail com> KC Rippstein hotmail com> is offline
external usenet poster
 
Posts: 168
Default Convert PDF to Excel?

If it exports to Word nicely, you can then export it to Excel from there.
You can just save it as a text file and then import the text file using
Excel's wizard. If it isn't separating into the columns properly using the
wizard, then Excel has a feature called Text to Columns under the Data menu
that will help you.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"MC" wrote:

I am looking to convert a PDF file into an Excel File.

My file is basically a company business report with line items that have
corresponding numerical values. I would like the line items in one column and
the numerical values in another. I have been struggling to save the file in a
way that I can open it like this, as I used to be able to do when I could get
the file as a PDF Forms file.

When I save as text, it can open nicely in Word, but it will not open with
the columns I need in excel. When I do Select Table/Copy Table/Save Table
through Acrobat I can get the values I want, but it's a struggle and I need
to do it section by section.

Please let me know if you have any suggestions.

I emailed the PDF file to the adobe2html email address last week and got No
response.

Thank you so much.