hi,
your problem is not uncommon perticularly when importing unformatted text.
high lite the column of the imorted text then go Datatext to columns
follow the wizard. if you have never used this feature, you may have to play
with it a little because it can get tricky depending on how the text is layed
out.

regards
FSt1

"Brendan" wrote:

I am trying to open a text file with Excel 2003. When the file opens in
Excel it is not in it;s appropriated columns. Instead, the data are streched
across the screen in continuous rows. I need to be able to select a column
of data, but the data are not in separate columns. I have imported similair
data files succesfully, but I have six files that will not import properly.
I would be happy to send the file to someone if this description is unclear.
Thank you for any help you may offer,
Brendan