If you do File|Open and select the .txt file (you wrote .txt in your response),
you can shift-click on the Open button and excel will put it all in column A.

Henrik wrote:

Thanks, David, that works. It is of course a bit of a workaround -- is there
really no way to do this straight from a .txt file?

"David Biddulph" wrote:

Rename the file from .csv to .txt.
Open it from within Excel as a delimited file, but unselect comma or any
other potential delimiter.
--
David Biddulph

"Henrik" wrote in message
...
I have a .csv file where a few records are 'split' across multiple columns,
I
presume because they have a comma (or similar) in them. All other records
remain in the A column.

That is annoying because Isubsequently need to manipulate all records in
the
same way (using 'Text to Columns'and other manipulations). It is thus
essential that *all* records *stay* in the A column, i.e. that no 'Text to
column' type functionality engages immediately upon opening the csv file.

Is there a way to ensure this does not happen, i.e. that all records stay
in
column A?

Thanks




--

Dave Peterson