I am hoping you can help. I have a several graphs that plot monthly results.
For each graph, there is a text box that contains the annual results to
date. The format of the text box is:

YTD
Objective 1000
Actual 2000

The objective results are in A1 and the actual results are in A2.

In cell B1 I wrote a formula: ="YTD"&"Objective "&A1&"actual "&A2
Then I linked B1 to the text box.

The problem is the text all comes out on one line. I have to shrink the text
box size and insert spaces to get it to the correct format. Is there an easy
way to write this formula with the correct format?