how to convert text to formula

[mohammed-ali]

hi
i have formula

=CONCATENATE("=","VLOO","KUP(D2,A","1:B2,2,0)")
or
="="&"VLOO"&"KUP(D2,A"&"1:B2,2,0)"

the result is
=VLOOKUP(D2,A1:B2,2,0)
but it only text


="1"&"+"&"2"
or
=CONCATENATE("=","1","+","2")

the result is
=1+2
but it only text

so how to convert result to be formula not text

[MarvinP]

Hi mohammad-ali,

I think you are looking for the "Evaluate" function.

See
http://www.myonlinetraininghub.com/e...luate-function or
http://superuser.com/questions/25335...were-a-formula

[Karnik]

Hi MarvinP,
Simplest way is to copy and paste in notepad, again copy from notepad and paste in Excel cell
It works
Karnik

[Regality]

You can solve it using the INDIRECT function too.

http://www.contextures.com/xlFunctions05.html