merge cells and keep formating text

English
, ,
#1

I merge 4 columns (L1 =A1&B1&C1&D1 and fill ) in column C the text is red and i want to keep this to the merged column L. How can do this ?

#2

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.