Making SQL Server Express Query Output Play Nice With Excel

Ever wanted to export a query from SQL Server Express into Excel only to be frustrated by embedded newlines in one or more of your cells? The solution is easy:


REPLACE(REPLACE(<cell_name>, CHAR(13), ' '), CHAR(10), ' ')