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)&AE...
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>"
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!
