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 Assistant Head of School for Academics and Strategic Initiatives at
Life saver. Thank you