Contenate in formula string

R

Rodolfo

i'm trying to use the concatenate function to build a formula string
refering to different cells. I'm trying to get this formula string:

=[VALORIZACION.xls]DOS001!$C$27

Using ="=[VALORIZACION.xls]"&A22&"!$C$27" in wich A22 value is DOS001.

Since this doesn't work i copy paste special values and get the
strings, but the remain as text, i have to clic on every cell and place
the cursor at the end of the string and the press enter for the string
to work as a formula.

Any suggestions how can i solve this?

Thanks in advance
 
Top