Shemelle has attended:
Excel Intermediate course
Opening PDFdocuments in Excel.
Hi,
I have a PDF document that contains 400 pages with many continuing tables inside. I am trying to open the PDF document in excel so I can edit 91 pages from the 400 pages in the attire document. I Want to be able to edit the document in excel with all the information still being displayed in their individual tables that was originally created in Excel before being formatted into a PDF document. I do not have the original excel document before it was reformatted into a PDF hence why I need your help to open or export the PDF back into Excel to edit while staying with the visible tables.
Please call me on 020 7582 7766 and ask for Shemelle or email me directly on ssoyebo@clsholdings.com if you need me to explain in more detail or would like me to forward on the PDF.
Kind Regards
RE: Opening PDFdocuments in Excel.
Hello Shemelle,
Thank you for your question. Unless you have the full Adobe Acrobat app, which has a tool that exports PDF tables to Excel, you can first open the PDF doc in MS Word (2013 and 2016 versions). Word will convert the data into Word tables, which can then be easily copied and pasted into Excel. This is because Word and Excel are both MS Office apps and can share data seamlessly.
After you have opened the PDF in Word, select the specific tables you wish to export, copy them and then select a cell in Excel where you want to start pasting.
I hope this helps. It works for me.
Kind regards
Marius Barnard
STL
