Font within concatenate

[Guest]

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

 

[Ron Rosenfeld]

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

 

[Guest]

Thanks for your help.

Not possible as such, as far as I know.


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