Thanks for the suggestions guys.  I used some vb code to treat the file the same way as an excel file.  For some reason Excel is able to correctly identify...

ROW 1

"THOMAS J","Person","4 street","town","city","country",000,000,000,9999

ROW 2

"person2","person2","59 street hall,","Mount Saint Annes,",000,000,000,0000

ROW3

"person2","person3","99, main street,","Some place, again,",000,000,000,0000

All the quotes are double quotes.  Turning of all delimiters creates one column.  This would...