Combine Text & Cell Reference, shape text box

[ilcaa]

i dragged a shape text box onto a chart. I want to display text and cell reference..

i select the shape textbox, formula bar ="QTD" & $i$96" error: "The Formula is missing a range reference or a defined name"

alone cell reference works fine.. how do i make this work. thanks

 

[JoeMo]

Select an empty cell, for example, let's say that's Z1.
In Z1 enter ="QTD"&$I$96
Select the textbox and press F2 key to place the cursor in the formula bar
enter =Z1 and press enter

 

[ilcaa]

Select an empty cell, for example, let's say that's Z1.
In Z1 enter ="QTD"&$I$96
Select the textbox and press F2 key to place the cursor in the formula bar
enter =Z1 and press enter

oh so everything needs to be in the cell, cant concat within formula bar with shape text....got it! thanks

 

[JoeMo]

oh so everything needs to be in the cell, cant concat within formula bar with shape text....got it! thanks

You are welcome - thanks for the reply.

 

[ilcaa]

oh so everything needs to be in the cell, cant concat within formula bar with shape text....got it! thanks

Select an empty cell, for example, let's say that's Z1.
In Z1 enter ="QTD"&$I$96
Select the textbox and press F2 key to place the cursor in the formula bar
enter =Z1 and press enter

You are welcome - thanks for the reply.

is there a way to enter a newline char in this cell to display in shape textbox as newline... i entered 'alt+enter' in cell it shows as newline but not in textbox...thanks

 

[JoeMo]

is there a way to enter a newline char in this cell to display in shape textbox as newline... i entered 'alt+enter' in cell it shows as newline but not in textbox...thanks

In Z1: ="QTD"&CHAR(10)&$I$96