How do I fix a delimited file sent in Excel 2002?
When you import a text file the wizard comes up with a window where you
can select "delimited" or "fixed width".
If you select "delimited" the next screen will show you a preview of
the data and will let you choose the type of delimiter. If you pick one
it will show the impact in the preview window. If what you see seems to
be correct, go further.
If you don't think there is a sensible result with delimiters, try
choosing "fixed" on the first screen.
This will bring up a screen with a preview of your data along with a
desription of how to split the rows into fields. Basically it's like
setting tabs in Word.
Hope this helps.
Hans
|