How to concatenate cell & text in a text box?

[Jimbo213]

I've searched this, and other, sites. I think the answer is "can't be done"
but I thought I'd ask the experts.

I have a text box on a graph that refers to a cell.
Text box has =Sheet1!A1 for example

I would like it to have this cell value AND a text value.
=Sheet1!A1 & " TextMessage"

My searching shows that can only be done by performing the concatenation in
a second cell and linking the text box to that second cell.

QUESTION: is it possible to do this concatenation within the text box only?

Thanks.

 

[ryguy7272]

You can do what you propose quite easily... Reference the Sheet name and the
cell, just as you did, and put the number that you want into the cell. I use
something like this:
TextBox:
=Simulation!$AJ$30
Cell AJ30:
="Min = "&TEXT(MIN(B3:B1002),"##%")


Regards,
Ryan---

 

[Jimbo213]

what does the mask "##%" do?

 

[ryguy7272]

Type 'TEXT' into the Excel help menu and you will see this:
Syntax

TEXT(value,format_text)

Value is a numeric value, a formula that evaluates to a numeric value, or
a reference to a cell containing a numeric value.

Format_text is a numeric format as a text string enclosed in quotation
marks. You can see various numeric formats by clicking the Number, Date,
Time, Currency, or Custom in the Category box of the Number tab in the Format
Cells dialog box, and then viewing the formats displayed.

The '##%' is a method of formatting for the text.
If you right-click a cell, click format cells > custom, you will see a bunch
of formatting options...

Regards,
Ryan---