Ad

Excel Gets Incomplete Line From CSV

- 1 answer

Excel displays the following line incomplete : Actual line:

"- Guides students through the new course and assessment structure with advice at the start of the book to help them understand what's required- Enables students to put their knowledge in context and helps them start analysing business data with case studies of real businesses included throughout- Prepares students for assessment with the 'Your turn' feature that contains practice questions including multiple choice, case study and data response, and those that test their quantitative skills"

Excel Displaying the incomplete line

- Guides students through the new course and assessment structure with advice at the start of the book to help them understand what's required- Enables students to put their knowledge in context and helps them start analysing business data with case studi

Please help

REgards

Kris

Ad

Answer

Okay, this is apparently a bug in Excel.

Because the text has a leading dash "-", Excel first tries to parse it as a number which is limited to 255 characters, but when that fails and it switches back to General, it never restores the text to the 32767 character limit.

See this answer at SuperUser for a more thorough answer and a workaround.

A workaround is to avoid having a leading dash. The fix is to declare the column as "Text" instead of "General" in the CSV Importer.

Ad
source: stackoverflow.com
Ad