Forum Discussion
Concat with formatting
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?
How about
=I2&CHAR(10)&CHAR(10)&K2&CHAR(10)&CHAR(10)&AE2&CHAR(10)&CHAR(10)&L2&M2&CHAR(10)&CHAR(10)&N2&O2
="<p>"&TEXTJOIN("</p><p>", TRUE, I2, K2, AE2, L2&M2, N2&O2)&"</p>"
Have you tried saving as a web page (.html)?
HansVogelaar Thank you for this suggestion. I have attempted this solution however the POS system does not upload (import) html files.
How about
=I2&CHAR(10)&CHAR(10)&K2&CHAR(10)&CHAR(10)&AE2&CHAR(10)&CHAR(10)&L2&M2&CHAR(10)&CHAR(10)&N2&O2
="<p>"&TEXTJOIN("</p><p>", TRUE, I2, K2, AE2, L2&M2, N2&O2)&"</p>"
