the last time I did something like this, I went around the problem by using
four text boxes inside a rectangle and had no lines around the text boxes. I
other words, I couldn't make it do what I wanted.

"Greg A" wrote:

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?