convert text to formula

[merlin_the_magician]

Little riddle:

i have a formula that shoud defenately work. Problem: it was put togeter as text and therefore not working.
How can i convert it to a working formula?

Note: i do NOT want to use MOREFUNC !!!

 

[redkat]

Thanks for this fantastic tip. I replaced = with = and it worked a treat!

 

[Richard_R]

I'm Using Excel 2016 and unfortunately the {Find}{Replace} technique mentioned did not work. However, I did find that the following actions did :-
1) Highlight the data range with the formula as text (only 1 column at a time allowed)
2) Using 'Text to Columns' option, accessable from the following menu tabs (in Excel 2016):{Data};{Text-to-columns};{delimited};{Next} -(uncheck all boxes){Finish}. This achieved the desired outcome

 

[Test123456]

If you have a formula, say

=VLOOKUP(I2,B2:N2001,11,FALSE)

and it shows up as text in an Excel cell, then you have to go -> Edit->Find->Replace and 'replace' any part of the text with the same thing for instance ',FALSE)' with ',FALSE)' then it will recognise and convert it to a formula.

Hi, I used to be able to do this. It was a wonderful solution, easy and quick.

However, for some reason after new year when I try to replace = with a = it tells me that "There's a problem with this formula." "Not trying to type a formula? When the first character is an equal (=) or minus (-) sign.....

Can see from image below. Any idea why?