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