2 different formats of text in a single cell?
Thanks, how would I format part of a text constant?
"Rick Rothstein" wrote:
You can't bold or italicize (or do any other font formatting to) part of a
string of text if that text is displayed as the result of a worksheet
formula... only text constants can have parts of its text formatted
differently from the rest.
--
Rick (MVP - Excel)
"mopgcw" wrote in message
...
Is it possible to have more than one format for a text string in a cell?
For example, I have the formula:
=i_currency&TEXT(+$C$13/landarea,"#,###.##")&"/"&landunit,"")
How can I bold or italicize part of the text string?
thanks
George
|