First copy the result of the formula and paste it as Special Value. Then
you can format the individual sections of the text.
--
Gary''s Student - gsnu200764


"Sliver Rayne" wrote:

Below is an example of my concatenate:
=CONCATENATE(" ",(A34), " produced ", "Total Sales of ",
DOLLAR(O81,0), ...............................

Result would be: Tick Promo (red/bold text) - produced total sales of -
(normal/black text) - $100 (red/bold).

I want to have the output of the cell reference to be bold and red but the
rest of the text to remain normal, black. Any ideas?

Karrie