Opening PDFdocuments in Excel.

Resolved · High Priority · Version 2013

Tue 15 Aug 2017, 16:15 Delegate Shemelle said...

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

Thu 17 Aug 2017, 12:53 Trainer Marius said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips