Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I want to combine columns of texts while preserving the formatting (e.g., underline, italics). How can I do that?
I know how to use =C1&CHAR(10)&C2 ...
but the formatting is lost.
This is not possible. You will need to assign text formatting again after you merge it:
Required, but never shown