Color within Concatenate

[BillCPA]

I have a concatenate formula - CONCATENATE("blahblah",A4,"moreblah") - that
pulls in part of the string from a cell (A4). Is there any way to change the
characteristics of just the A4 value (bold, red, etc.) within the concatenate?

 

[Gary''s Student]

Copy the cell with the formula and paste/special/value back onto itself.
Then format the string portion manually.

 

[alexrs2k]

It's mot possible within a formula. This post will clarify any doubts.

http://www.excelforum.com/excel-programming/468064-concatenate-format-color.html