Ok my bad, didn't know how to properly explain it before; the data looks like this:
Quote:
"1175","MONTGOMERY, BILLY","SYSNETCORP","BILLY MONTGOMERY","Owner/CEO","8647 RICHMOND HWY STE 637","","ALEXANDRIA","VA","22309-4316","Workstation and Server<enter> Maintenance and Installation<enter>
Router Installation and Configuration<enter>
Firewall Installation and Configuration<enter>
LAN and WAN Design"
|
Quote:
"first","second","third","forth, 4th"
"first","second","third","forth - 4th"
"first","second","third","for<enter>
th"
"first","second","third","forth, 4th"
|
basically the last section has variations (dashes, slashes, commas)
within the quote marks, but what seems to be screwing up the import is the <enter>'s. So whenever someone has entered data and hit <enter>, like in the example, the next line is messed up in excel.