3 ways to remove carriage returns in Excel: formulas, VBA macro ...

How to remove carriage returns (line breaks) from cells in Excel 2010, 2013, 2007 ... will help you replace line break with any other symbol (comma+space).

www.ablebits.com