Results 1 to 2 of 2

Thread: Trying to save excel spreadhsheet in tab delimited text file and the columns are screwed up

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Adar's Avatar Just doing it
    Civitate

    Join Date
    Oct 2007
    Location
    Sweden
    Posts
    6,741

    Default Trying to save excel spreadhsheet in tab delimited text file and the columns are screwed up

    I need to create a plain text file to load into a statistics program called Rosetta. I have attached the faulty txt file and the spreadsheet that I have in excel to create it. The original data is from the Stanford HIV database but in the example I only use a few of the rows and columns since it is easier to work with.

    There is a huge amount of crappy webpages with basic advice that makes it hard to find anything useful so does anyone here have good ideas?

    Excel spreadsheet of course failed.
    Last edited by Adar; May 20, 2011 at 10:21 AM.

  2. #2
    irishron's Avatar Cura Palatii
    Moderator Emeritus

    Join Date
    Feb 2005
    Location
    Cirith Ungol
    Posts
    47,023

    Default Re: Trying to save excel spreadhsheet in tab delimited text file and the columns are screwed up

    I just opened it in Notepad with no problems. You can save it in other formats in Notepad++.

Posting Permissions

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