Import to Excel?

coccio

Board Regular
Joined
Mar 19, 2002
Messages
156
Office Version
  1. 2016
I have question in regards to extracting data from one document and importing it into excel. Does anyone know how to do that? Were one can take certain data within a PDF file or MS word document and import it into excel?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
To import from Word or any text file, Choose Data>Get External Data.Import Text File. The Wizard will walk you through the steps. As far a PDF files go, that's not very easy
 
Upvote 0
Or...

You can copy it from your .doc or .txt or? and paste in in a single cell, I usually use
a1, and then go to Data>Text to Data and follow the Wizard.
As far as .pdf goes, I think you need at least Acrobat 5.0 ( full version not just the reader ).

Good Luck,
Wesley
 
Upvote 0
You can also copy and paste in as a link if you have pictures, wierd fonts, etc.

Edit Menu>>Paste Special>> Follow instructions.
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,326
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top