Concatenate whilst keeping formatting

  • Thread starter Thread starter DJ
  • Start date Start date
D

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.
 
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.
Click to expand...

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
 
Back
Top