Format only parts of a formula result?

S

sdubose99

I created a formula composed mostly of text, including a small formula.
This formula:

="The products would be $"&ROUND(E28/1000,0)&"K but since new revenues
are enabled almost instantly,"

is intended to produce:

The products would be $1335K but since new revenues are enabled almost
instantly,

Is there a way to BOLD or ITALICIZE the "$1335K" result but leave the
other text unbolded?

Scott
 
D

Dave Peterson

Not and keep it a formula.

Formulas don't work with this kind of character by character formatting--and
neither to numbers.
 
Top