Concatenate whilst keeping formatting
 

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.

Concatenate whilst keeping formatting
 

No. A formula can't do that.
--
David Biddulph

"DJ" wrote in message
...
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.

Concatenate whilst keeping formatting
 

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