Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2006
    Posts
    76
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Txt data into Excel (2003)

    Is there a way to import data from a text file, into a similarly formatted excel spreadsheet?
    Sort of like using the data in the Txt file as the table_array in a vlookup formula?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Txt data into Excel (2003)

    You can use File | Open to open a text file in Excel.
    If you wish to import into an existing worksheet, you can use copy and paste (or paste special)
    If you have special requirements, you may need a macro.
    If you need more help, please provide some details of what you want.

  3. #3
    Star Lounger
    Join Date
    Mar 2006
    Posts
    76
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Txt data into Excel (2003)

    I didn't realize you could open the text file in Excel, I was using Copy and paste previously. But with 27k lines of text it gets quite tedious.
    The File | open does the trick, thanks again for your help!
    Tom

  4. #4
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Txt data into Excel (2003)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    You can also use the Import External Data tool, in the Data menu.
    This has the advantage that the data can be refreshed in the workbook whenever the source data changes.
    There's a good tutorial (Word or Powerpoint) at
    http://www.microsoft.com/education/e...2tutorial.mspx

  5. #5
    Star Lounger
    Join Date
    Mar 2006
    Posts
    76
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Txt data into Excel (2003)

    Thanks John,
    I'll try your suggestion as well!
    Tom

Posting Permissions

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