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), ' ')

Leave a Reply

Your email address will not be published. Required fields are marked *