Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    Hyderabad
    Posts
    5

    Unanswered: Is this possible ?

    I have a space delimited text file and I want to insert/copy the data from that file into a excel spreadsheet such that each data point goes into a different cell.

    Any suggestions on how this might be done ?

    Thanks in advance

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Is this possible ?

    Open a new excel worksheet ..

    Open the space delimited text file ... Ctrl-A here followed by Ctrl-C

    Go to the spreadsheet and Ctrl-V ....

    Click on the menu item 'Data' and in the pull-down menu select Text to columns ...

    Follow the prompts ...

    The other option will be to do

    Data --> Import External Data --> Import Data Menu to get the same job done


    HTH

    Sathyaram

    Originally posted by geeorbit
    I have a space delimited text file and I want to insert/copy the data from that file into a excel spreadsheet such that each data point goes into a different cell.

    Any suggestions on how this might be done ?

    Thanks in advance
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    sai ram with u

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    ???


    Originally posted by joev57
    sai ram with u
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Sep 2003
    Posts
    4
    itis only hello to you

  6. #6
    Join Date
    Sep 2003
    Location
    Hyderabad
    Posts
    5
    Thanks Sathyaram.
    The convert text to column method works well.
    I had tried the import method but that was giving Run Time error 1004 for the command
    .Refresh BackgroundQuery:=False

    So I was looking for alternate methods to do this.

    Thanks again

Posting Permissions

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