Replace Carriage Returns in Excel

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

One comment

  1. Richard73 says:

    Life saver. Thank you