Listing Results

[TCouch]

Is there any way to change the export format of a list file. The problem I am having is that I save my data as a list file, but when I open it with Excel some of the results run together because there is no space between columns. Or is there a way to change the size of the columns in the lists.

 

[Dave442]

You can delimit data by space, comma etc. in Excel.

In MS Excel 2007 what I usually do is:
Data->From Text->FILE.lst

Then in the text import wizard select "delimited" and click "next". Then when given the options of delimiters check the box for "space". You should see black lines seperating the columns in the preview box below.

If you have no space between the columns you can delimit the columns by a fixed width using the text import wizard. If I understood your question, this should work.

Hope this helps,
Dave

 

[TCouch]

A space delimiter was what I was using that was giving me problems, I didn't even think about looking for any sort of fixed width. Right in front of my face. Thank You for the help, it is much appreciated.

Thanks,
Todd