keep source formatting when concatenating

[cstwoplus]

In cell A1, my data are in bold font and underlined. In cell B1, my data are
in bold font only. In cell C1, my data do not have any special formatting.
When concatenating to D1 (=CONCATENATE(A1&" "&B1&" "&C1), the source
formatting is not displaying in D1, i.e., nothing appears bolded or
underlined. Is there a way to do this?

 

[Dave Peterson]

You have two problems.

#1. Formulas don't allow this kind of formatting.
#2. Worksheet functions like this bring back values--not formats.

Maybe you can convert to values and reformat that?????