+ Reply to Thread
Results 1 to 4 of 4

Import 2 text files into 2 separate columns?

  1. #1
    Registered User
    Join Date
    02-07-2006
    Posts
    7

    Import 2 text files into 2 separate columns?

    This is probably wishful thinking, but is there a way to import one text file into Column A, for example, and another text file into Column B, so they line up next to each other ? They are large files, so I don't want to have to cut and paste, if possible.

    Thanks for any help !

  2. #2
    flummi
    Guest

    Re: Import 2 text files into 2 separate columns?

    Click A1
    select data-->get external date-->import text file
    click your way through

    then click the next where you want the other file to appear
    do the same

    Hans


  3. #3
    Nick Hodge
    Guest

    Re: Import 2 text files into 2 separate columns?

    You don't give any version details, but if this is XP or 2003 then go to
    Data>Import External Data>Import Data. This sets an OLEDB connection where
    you can select any datasource. (.txt files are one). You then get what looks
    like the text import wizard dialogues, with a few bells and whistles, once
    you complete this wizard you get asked where to put the data, select A1,
    then do the same on file2 and select B1

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    www.nickhodge.co.uk
    [email protected]HIS


    "tcurrier" <[email protected]> wrote in
    message news:[email protected]...
    >
    > This is probably wishful thinking, but is there a way to import one text
    > file into Column A, for example, and another text file into Column B, so
    > they line up next to each other ? They are large files, so I don't
    > want to have to cut and paste, if possible.
    >
    > Thanks for any help !
    >
    >
    > --
    > tcurrier
    > ------------------------------------------------------------------------
    > tcurrier's Profile:
    > http://www.excelforum.com/member.php...o&userid=31279
    > View this thread: http://www.excelforum.com/showthread...hreadid=511362
    >




  4. #4
    Registered User
    Join Date
    02-07-2006
    Posts
    7
    Thanks for you help, guys... It works great.. I didn't realize that option was there....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1