i have a textbox i use as a chart header, so when data changes so does the
header. so, if the data is in cell a1, i use =a1 for the textbox to display
the data.

my question is, is there anyway to concatenate 2 cells in the textbox
formula? if i try =a1 & a2 for the textbox formula, i get an error.

so, do i have to concatenate the data in a separate cell and then reference
that cell for the textbox formula?
--


Gary