I'm wondering if it is possible to have a different font for a certain part
of a concatenated text.

Ex. =concatenate(text1,text2,text3) where text2 is bold and text1 and text3
would not be bold.

Thanks

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

Thanks for your help.

"Ron Rosenfeld" wrote:

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