How do I concatenate text to keep the text's original color/font/s
 

Is there a formula command that will concatenate or merge text so that the
original formatting of the cells from which the result is being concatenated?

No. Depending on your purposes, e.g., if the format would always be the
same in the source cells), you could use a VBA event macro to replace
the formula.

In article ,
Temp_User wrote:

Is there a formula command that will concatenate or merge text so that the
original formatting of the cells from which the result is being concatenated?