Text Formatting when using CONCATENATE

[Mapper]

I have several columns of data and I'm using the CONCATENATE function to
combine the data into one column on the right, which is simple enough.
But I need to extend on this by keeping the formatting of the text as
it appears in the original columns.

For example, if Column A is Bold (*ONE*), but Column B is italic
(-TWO-), how can I have the text in the result column keep the original
formatting (*ONE* -TWO-).

This is a problem which has had me lost for ages, so any help or
suggestions would be greatly appreciated.

Steve

 

[Bernie Deitrick]

Steve,

You can't do that with formulas. You would need to use worksheet event code
to combine the two formatted strings together into a single string that
retains the formatting.

HTH,
Bernie
MS Excel MVP