Concatenate whilst keeping formatting

[DJ]

I'm trying to work out if it is possible to concatenate various text strings
whilst maintaining the format of the text. Within a single text sting some
words will be highlighted in colour or bolded - eg for ingredient lists.

 

[Ron Rosenfeld]

I'm trying to work out if it is possible to concatenate various text strings
whilst maintaining the format of the text. Within a single text sting some
words will be highlighted in colour or bolded - eg for ingredient lists.

In order to "differentially" format a string within a cell, it must be
converted to an actual text string. The individual segments can then be
selected and formatted. This can be done manually, or by using a VBA Macro.

You cannot do this with a formula.
--ron