I am unaware of any way to do this.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Tired of poor table nagivation"
. com wrote in message
...
I want to change from a large font size of the first word in a cell to a
smaller font size for the remainder of words, for cel text that is built
up
multiple text cells via a formula. This type of formatting is quite easy
for
a text (not formula) cell (just select the portion of text you want
different
and change font, size, color, etc.). However, I haven't been able to find
the set of operators/modifiers to accomplish the same thing within a
formula.

Please help. Thanks