Font within concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
I'm wondering if it is possible to have a different font for a certain part
of a concatenated text.
Click to expand...

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.
Click to expand...

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 said:
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
Click to expand...
 
Back
Top