https://community.qlik.com/t5/Data-Quality/Inserting-a-carriage-return/m-p/2261249#M1630 Hello&nbsp; <BR />It is impossible to do it so far. <BR />Regards <BR />Shong Mon, 10 Oct 2016 09:01:40 GMT Anonymous 2016-10-10T09:01:40Z https://community.qlik.com/t5/Data-Quality/Inserting-a-carriage-return/m-p/2261248#M1629 Hi&nbsp; <BR />I am trying to consolidate mailing address fields and I would like to be able to concatenate Mailing Line 1 and Mailing Line 2 but with a carriage return as the separator. Does anyone know if this is possible?&nbsp;&nbsp;I could not find a way to do it and worked around it by exporting to excel but I love the Prep Tool and would love to be able to do all my manipulations within the tool.&nbsp; <BR />Thanks!&nbsp; Sat, 16 Nov 2024 10:21:24 GMT https://community.qlik.com/t5/Data-Quality/Inserting-a-carriage-return/m-p/2261248#M1629 Anonymous 2024-11-16T10:21:24Z https://community.qlik.com/t5/Data-Quality/Inserting-a-carriage-return/m-p/2261249#M1630 Hello&nbsp; <BR />It is impossible to do it so far. <BR />Regards <BR />Shong Mon, 10 Oct 2016 09:01:40 GMT https://community.qlik.com/t5/Data-Quality/Inserting-a-carriage-return/m-p/2261249#M1630 Anonymous 2016-10-10T09:01:40Z