Replace Carriage Returns in Excel
Posted by: rkassissieh
June202007
While migrating some data from Excel to mySQL, I came across the following life-saving tip.
create a second column =SUBSTITUTE(SUBSTITUTE(A2,CHAR(13),""),CHAR(10),"
"). This will handle both UNIX and Windows carriage return-line feed combinations.
source
Richard Kassissieh is Director of Information Services at 
RSS 2.0 