can you format part of a formula return bold?

[Cloverken]

Hi All,

I was trying to figure out without VBA if you can format bold part of a result from a formula. such as

=If(A1>100,"Mr"&" Smith","")

the formula result would be Mr Smith if cell A1 is 101.

Can I make the "Mr" of this return BOLD and the Smith regular such as.

Mr Smith

Thanks
Ken

 

[tactps]

Without VBA the only way would be to break this formula into 2 columns and bold the first:
=If(A1>100,"Mr","") in cell B1 (bolded)
=If(A1>100," Smith","") in cell C1 (normal)

 

[Cloverken]

Thank You for the answer

Ken