Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Import to Excel?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    137
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Atlanta,Ga
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Waterdown, Ontario
    Posts
    464
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can also copy and paste in as a link if you have pictures, wierd fonts, etc.

    Edit Menu>>Paste Special>> Follow instructions.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •