Function In A Text Box

[tubbsy]

Hi,

I am trying to put a concatenate function in a text box. The error message is as follows:

The text you have entered is not a valid reference or defined name.

I want to concatenate some text with a number from the cell, A2.

Any ideas would greatly appreciated.

Regards

Tubbsy

[giantwolf]

Its not a perfect solution but you could perform the concatenate function in another cell, maybe hidden on another sheet, and then reference that cell in the text box.

GW