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