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
Life saver. Thank you