How to address line breaks in CSV Files
Found this pearl. Useful when moving data using the Data Wizard or the straight import facility of CRM.
“What i’ve always done (this is a hack but it works) is to save my CSV file in html format (via Excel). Then you can open the HTML file and do a find-and-replace for all <br>’s (line breaks) and <p>’s (paragraphs) with an escape character like ” / “. Then save the file, re-open in Excel, and save-as CSV. This gives you a new CSV file without the line breaks”
Source: Ryan Casey’s answer to this thread: How can I import data (CSV) with line breaks?
Alberto “Break Like The Wind” Gemin