I have concatinated two cells to create a function and I can cut and past
special the values for that function but it is not until I select the cell
contents and press enter that the function works.

example:

A1 has an equal sign
A2 has C1 where C1 has the number 12
on A3 I code =A1&A2 and it shows =C1
I can copy and past special this onto A4 and it shows =C1 but it will not
show the 12 in C1?

thanks