Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jul 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to import text files to worksheet ? (excel 97)

    hi,
    i'm able to import text files by using excel 2000 --> from menu DATA --> GET EXTERNAL DATA ---> IMPORT TEXT FILE

    however, it seem excel 97 dont have this functions. Is there anyway i can import text file using excel 97
    to spreadsheet?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to import text files to worksheet ? (excel 97)

    You should be able to just use the File Open, change the file type to whatever is appropriate, navigate to the file and open it. If the file is not something that Excel can automatically understand, it should bring up the import wizard to let you tell it what to do.
    Legare Coleman

  3. #3
    Lounger
    Join Date
    Jul 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to import text files to worksheet ? (excel 97)

    hi.
    thanks.
    can it be necessary for me to change excel 97 straight away have the import functions at the DATA menu just like Excel 2000 ?
    --> menu DATA --> GET EXTERNAL DATA ---> IMPORT TEXT FILE

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to import text files to worksheet ? (excel 97)

    I don't know for sure and I don't have XL97 available to look. Here is how you would do it if it is possible:

    1- Right click on an unused area of your menu bar and select Customize from the pop up menu.

    2- In the Customize dialog box, click on the Command tab at the top.

    3- In the list box on the left side, click on Data.

    4- Scroll down the list of commands on the right side and see if there is one for Import Text File.

    5- If the command is there, then click on the Data command in your menu bar to drop down the Data menu.

    6- Drag the Import Text Files from the Customize dialog box and drop in on the Data menu in the position where you want it (a line should show you where it will be placed).
    Legare Coleman

  5. #5
    Lounger
    Join Date
    Jul 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to import text files to worksheet ? (excel 97)

    thanks alots for your help legare.

Posting Permissions

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