Excel显示以下行不完整：实际线路：
"- 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显示不完整的行
- 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
请帮助
REgards
Kris
好吧，这显然是Excel中的一个错误。
由于文本有一个前导短划线"-"，Excel首先尝试将其解析为一个限制为255个字符的数字，但当解析失败并切换回"常规"时，它永远不会将文本恢复到32767个字符的限制。
有关更全面的答案和解决方法，请参阅SuperUser上的此答案。
一种变通方法是避免使用前导破折号。修复方法是将列声明为"；文本"；而不是"；"概述"；CSV导入程序中。