Formatting for linked textbox on worksheet

[artz]

Hi,

I am using Excel 2016 on Windows 10 and am having trouble getting the textbox formatting that I desire.

I am concatenating two worksheet cells, P3 containing the text "Systolic Average" and cell R3 containing the numeric value.

These are combined in cell T3 using the worksheet formula:

=CONCATENATE($P$3, " ",$R$3)

When I link cell T3 to the textbox, I find that I am unable to set the formatting so that I can have the text "Systolic Average" appear in boldface while having the numeric value, "120.28" in plain text and rounded to 2 decimal places.

I can't find any examples online for textboxes with multiple formats for the contents.

Is this possible with a linked textbox?

Thanks,

Art