Suppose I have this formatted text in cell A7 of worksheet "myworksheet":
My bold and italic text.
I can get "My bold and italic 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?