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?