Why line breaks break imports
CSV allows line breaks inside quoted cells, but many importers, older databases and command-line tools treat each line as one record. A comment that contains an Enter key then splits a record in two and shifts every column after it. Removing line breaks makes the file safe for all of them.
Alt+Enter in Excel
Cells where someone pressed Alt+Enter (Option+Return on a Mac) contain line breaks that are easy to miss in Excel but cause broken rows elsewhere. The preview shows these cells on several lines so you can spot them before cleaning.
Using a different separator
To join lines with something other than a space, for example “; ”, use Find & replace instead: turn on Regular expression, find \r?\n and replace it with your separator.