Suppose I have this formatted text in cell
A7 of worksheet
My bold and italic text.
I can get this text to show up in a text box in a chart by setting the formula for the text box to this:
=myworksheet!A7 (Excel changes it to
That will get the text, but it won't keep the bold and italic formatting.
Is there a way to preserve the bold and italics in this scenario?