On Sun, 21 Dec 2008 22:10:01 -0800, DJ wrote:

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