Have done some more testing with no success in getting the issue resolved...

Below is a test task CSV file (with the middle of the file removed). If you
were to duplicate the 50 characters per line until you reach the 30515 total
number of characters for the Notes section (based on MS Word's Word Count),
and then import the csv file into excel, it causes the task to "wrap" to the
next row. If you remove say the last character in the Notes (so the total
number of characters goes to 30514), excel correctly imports the csv file
and the task remains contained on one row.

"Subject","Start Date","Due Date","Reminder On/Off","Reminder
Date","Reminder Time","Date Completed","% Complete","Total Work","Actual
Work","Billing
Information","Categories","Companies","Contacts"," Mileage","Notes","Priority","Private","Role","Sche dule+ Priority","Sensitivity","Status"
"Test CSV for Excel","11/30/2006","3/19/2007","True","3/19/2007","9:00:00
AM",,"0.050","0","0",,,,,,"12345678901234567890123 456789012345678901234567890
12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890

:
:
:

12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890
123456789012345
","Normal","False","",,"Normal","In Progress"


The above CSV file (when filled in to 30515 characters for "Notes") causes
problems when imported into Excel. It causes the "Notes" cell to overflow and
puts info for the cells following that onto the next line (or multiple lines
if you continue to add more characters).

(from MS Word of JUST the Notes text and NO delimiters or headers)

Word Count
Pages 10
Words 611
characters (no spaces) 30515
characters (with spaces) 30515
Paragraphs 611
Lines 611


The goal is to figure out how to get excel to gracefully TRUNCATE the info
from the Notes field, to say 30000 or even 25000 characters, when importing
the CSV file into excel, so the task remains all on one line. We are not
concerned about losing the "end" of the task notes. We are MORE concerned
about creating readable reports in excel.