Function In A Text Box

T

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
 
G

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
 
Top