+ Reply to Thread
Results 1 to 3 of 3

Text Import wizard

  1. #1
    Old Bob
    Guest

    Text Import wizard

    If I am in an excel spreadsheet and I try to open a .txt file, the test
    Import wizard used to open so I could determine columns and data etc. Now,
    when I try to open the file, the wizard does not open..excel opens with a new
    spreadsheet. How do I get the wizard to open again? My firm re-imaged my
    machine and all kinds of things are off.
    --
    Old Bob

  2. #2
    Amy Beth
    Guest

    RE: Text Import wizard

    If you right click on the file that you are opening and select "open with" it
    should give the option of excel, from there it should walk you through the
    wizard. It is a matter of needing make the .txt file using the "text to
    columns" feature? If you open it in excel and it has all the data jumbled
    together. You highlight column A and select "text to column" from there it
    will walk you through the delimited tab wizard.

    AB

    "Old Bob" wrote:

    > If I am in an excel spreadsheet and I try to open a .txt file, the test
    > Import wizard used to open so I could determine columns and data etc. Now,
    > when I try to open the file, the wizard does not open..excel opens with a new
    > spreadsheet. How do I get the wizard to open again? My firm re-imaged my
    > machine and all kinds of things are off.
    > --
    > Old Bob


  3. #3
    Old Bob
    Guest

    RE: Text Import wizard

    I'll give that a try--thanks
    --
    Old Bob


    "Amy Beth" wrote:

    > If you right click on the file that you are opening and select "open with" it
    > should give the option of excel, from there it should walk you through the
    > wizard. It is a matter of needing make the .txt file using the "text to
    > columns" feature? If you open it in excel and it has all the data jumbled
    > together. You highlight column A and select "text to column" from there it
    > will walk you through the delimited tab wizard.
    >
    > AB
    >
    > "Old Bob" wrote:
    >
    > > If I am in an excel spreadsheet and I try to open a .txt file, the test
    > > Import wizard used to open so I could determine columns and data etc. Now,
    > > when I try to open the file, the wizard does not open..excel opens with a new
    > > spreadsheet. How do I get the wizard to open again? My firm re-imaged my
    > > machine and all kinds of things are off.
    > > --
    > > Old Bob


+ 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