stevebriz wrote:
My thoughts are along the lines of Dave O
You can do this in VBA within excel
I would read the file the each line or all lines into a buffer and
replace the offending tabs, vb newline etc with a space. then delimit
on commas
Additioinally if the comments field has commas in it then then next
step would be to
Read it into a 2D array ( eg x,y) based on splitting commas and join
all from y=4
Hope this makes sense

Hmm, I was sort of afraid that would be the answer. ;) Saving the file
as a csv file and just using open instead of import gets me sort of
what you are talking about. No strangly broken lines BUT we also loose
the formatting within the last cell.

Since we want to preserve newlines (IE turn them into newlines within
the cell, I believe excel calls them hard returns?) what character
would I need to insert?