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

Yes, you'll have to concatenate the two cells in another cell, then link
the textbox to that cell.

Gary Keramidas wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

ok, thanks

--


Gary


"Debra Dalgleish" wrote in message
...
Yes, you'll have to concatenate the two cells in another cell, then link
the textbox to that cell.

Gary Keramidas wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Use the formula in the cell.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Gary Keramidas" wrote in message
...
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