In my SQL code I have the below code to remove LF and carriage returns. However, this column, when copy and pasted to excel or exported to excel is creating additional columns for this field when I want all columns in 1 field.
REPLACE ( REPLACE ( description, CHAR(13) , '' ) , CHAR(10) , ', ' ) AS Description
9/1/17 dho: Current LT is 3 wks., , *CC, LT: BONDED 25pc reels - 2wks - other suppliers for MOQ 1, AMU: 6, LPP: 286.50ea for reels - other suppliers 1: 350.00, LQP: 25 , LDP: 09.17.2015 ,
Below are going to different columns
LDP: 09.17.2015 ,