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