Cell formatting cannot be set by formulas. It is possible using code,
Try this link tp Chips site, he is good,
Regards,
Alan.
http://www.cpearson.com/excel.htm
"Greg Neill" wrote in message
. ..
Would anyone happen to know how to go about setting the
character attributes (bold, italic, ...) for a subset of
the characters within a string?

A particular example might clarify.
Suppose cell A10 contained the string: Mary
Suppose further that I wish to set the contents of cell C20
with: =CONCATENATE("I want ",A10," to go to the store.")

Now, how might I go about having the string copied from A10
take on bold or italic characteristics? I don't want to have
to place it in a separate cell and adjust the cell widths for
different length words...

A search of Excel's standard built-in functions didn't turn
up anything helpful, at least to my eye.

Any clues?