Font within concatenate
On Mon, 6 Feb 2006 19:46:27 -0800, Wes wrote:
I'm wondering if it is possible to have a different font for a certain part
of a concatenated text.
Not possible as such, as far as I know.
Ex. =concatenate(text1,text2,text3) where text2 is bold and text1 and text3
would not be bold.
You would have to convert it to a text string. Then you could bold a part of
the text.
Without using a VBA routine, you could copy the cell in which the formula is
located, then Paste Special Values.
Then you select a portion of the text (in the formula bar) and apply the
appropriate formatting to it.
--ron
|