BUT in the versions of Office I use all have configuration options to tweak how to handle .CSV files. I do not own Works or have access to it but it's a fair bet that it has some configuration feature.
-> Why not open that .CSV file with Works and see what happens rather than a cut and paste? If it opens proper you can cut and paster from that sheet to yours.
data xfer of CSV files Question
I used to write csv files in XP Works8 note pad.
Strings of data separated by comma, ie; 02,Rooster Cogburn,1975,Rooster Cogburn,x.
Then I would transfer the data CSV file to XP Works8 data base. Via cut & paste
The above line would be entered automatically into Five (5) separate fields or columns
of XP Works8 database or spreadsheet.
The same procedure does not work for me in Vista Works9.
What is the procedure for Vista Works9?