Formatting a cell with a concatenated formula

  • Thread starter Thread starter andy2812
  • Start date Start date
A

andy2812

Sorry for the double post but I'm not sure which is the best forum fo
this question so I've posted it in 2 different ones.

I have a concatenated formula that pulls text from 2 different cells
The 2 cells are formatted differently (i.e. 1 cell has blue text an
the other cell has red text and a different font) and I want to kee
these formats. However, the cell with the concatenated formula take
the format of that cell. Is there anyway to do this
 
Back
Top