Text Formatting when using CONCATENATE

  • Thread starter Thread starter Mapper
  • Start date Start date
M

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