Need to Bold Part of Formula

[samsilverman]

="I"&" "&ACCOUNT!$C$2&" "&"hereby certify"

I need to bold the ACCOUNT!$C$2 part of the formula above while everything else stays regular. Any suggestions?

I am using excel 2007. Thanks.

 

[VoG]

That isn't possible using a formula.

 

[Jonmo1]

So for example if
ACCOUNT!$C$2 = "John Doe"
Your resulting value is

I John Doe hereby certify

And you want to bold just the name

I John Doe hereby certify


Sorry, that can't be done within the formula.
You will have to convert the formula to a value (copy - Paste Special - Values)
Then either with VBA code or by hand, format just that part to bold.

 

[samsilverman]

Thank you
Thank you, too
BUMMER!