I am attempting to concat a number of columns together and add return formatting within the cell.  I am able to write the following formula with success. =I2&CHAR(10)&CHAR(10)&K2&CHAR(10)&CHAR(10)&AE2&CHAR(10)&CHAR(10)&L2&M2&CHAR(10)&CHAR(10)&N2&O2,

When I save this excel file, even as a csv and import this file into my POS (Point of Sale) program the POS does not recognize CHAR(10) as a return function.  In speaking with the support staff for my POS, this system will only recognize <p> & <p/> as return and paragraph functions to import.  Does anyone know how to use <p> & <p/> in and excel formula?

​I am attempting to concat a number of columns together and add return formatting within the cell.  I am able to write the following formula with success. =I2&CHAR(10)&CHAR(10)&K2&CHAR(10)&CHAR(10)&AE2&CHAR(10)&CHAR(10)&L2&M2&CHAR(10)&CHAR(10)&N2&O2,When I save this excel file, even as a csv and import this file into my POS (Point of Sale) program the POS does not recognize CHAR(10) as a return function.  In speaking with the support staff for my POS, this system will only recognize <p> & <p/> as return and paragraph functions to import.  Does anyone know how to use <p> & <p/> in and excel formula?  Read More

​