Unbold & use a different font on part of a cell contents

[mikeburg]

In a single cell B2, I have

= "John Doe Manufacturing Co 156 " & text(today(), "mm-dd-yy")

all in Ariel 10.

Is there a way to unbold the part: & text(today(), "mm-dd-yy") and use Ariel 8 on it & leave the 1st part Bolded with Ariel 10?

Thank you for your help. mikeburg

[robert111]

I suppose you could put today() in cell A1 and text(A1,"dd mm yy") in cell A2 formatted not bold and concatenate it with A3 which contains name and is bold....

Bob

[mikeburg]

Thanks, Bob. This is true. I just hate to have to modify all my sheets by inserting a new column. It will work though. Thanks a lot. mikeburg