×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Listing Results

Listing Results

Listing Results

(OP)
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.

RE: Listing Results

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

RE: Listing Results

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources