Keep Formatting when Combining cells

[Diffy]

Hi

I currently am using a formula like this to combine cells (In B1):

=A1 & Char(10) & A2

The formatting in A1 and A2 are different however. Is there something that I can add to my formula so that when I combine these cells the formatting of A1 & A2 stay?

 

[Norie]

Sorry the short answer is no.

You can't format the result of a formula without VBA and if you use that you need to convert the formula to a value, so obviously you lose the formula.

 

[Diffy]

Ahhhh man... That makes my work tedious!

Thanks anyway.