You can't do that with a formula. You'd have to replace the formula with
a _Calculate event macro that would do the calculation, insert the
result, then format the cell.

In article ,
Tired of poor table nagivation
. com wrote:

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