Concat with formatting

[tqk2215]

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?

[#2]

@tqk2215 

Have you tried saving as a web page (.html)?

[#3]

@HansVogelaar  Thank you for this suggestion.  I have attempted this solution however the POS system does not upload (import) html files.  

[#4 · Accepted solution]

@tqk2215 

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>"

[#5]

@HansVogelaar I can not thank you enough for helping with this formula.  It works perfectly and will save me literally days of additional work.  THANK YOU!  THANK YOU!