On Sat, 12 Dec 2009 16:40:01 -0800, Alex
wrote:

This is probably not possible, but I figure there's not harm in asking.

I know that if I have a cell containing "apples and oranges" and I highlight
"apples" and click the bold button, only "apples" will be in bold face and
"oranges" will stay regular. Is it possible to do this with a formula. What I
mean is this:

A1="apples "
A2="and oranges"
A3=A1&A2

Is there any way that in A3 only "apples" be in bold face?

Alex

To accomplish this, you could
Implement your formula in a VBA Macro
Have the VBA Macro output a text string to the cell
Format the text cell appropriately.

By using an event-triggered macro, you could almost emulate the functionality
of a formula.

Perhaps if you can be more specific as to your requirements ...
--ron