You can do it with a named range. Select the cell where you want evaluated
formula to appear. Now, go to Insert - Name Define.
Give your function an appropriate name (e.g. "Eval")
For source, input:
=EVALUATE($F7)

You can now type into a cell:
=Eval
and it will evaluate the the text string located in column F of that row.

Note: Even though it's a legitimate function in a defined name, sadly, you
can not type the EVALUATE function directly into a cell.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Basil" wrote:

Hi all,

I have a dataset where for every row in one field (ie Column F) I need a
different function to be performed based on the entry in another column (B).

As such, I have been able to create a text string that represents the
correct function to be evaluated for each of the cells in this Column F. The
problem is I don't know how to convert this function as text to be a function
that is actually evaluated.

To give you an example, the cell F75 contains this formula:
=IF(VLOOKUP(D175,Translation!$A$2:$D$40,2,FALSE)=" ",B175,TRIM(SUBSTITUTE(VLOOKUP(D175,Translation!$A $2:$D$40,2,FALSE),"B1",CELL("address",B175))))

The output is this text string:
=RIGHT($B$175,LEN($B$175)-SEARCH(" ",$B$175))

What I need is the evaluation of the above.

Is there a function that will generate this evaluated output?

I really need to avoid using code as once completed, this workbook will need
to be dynamic and sent to people in different companies, hence I need to
avoid the macro security issues.

Many thanks,

Basil