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