# Is it possible to convert a text string to a formula?

Is it possible to convert text to a formula or to otherwise run a formula in a different cell?

I am working on a series of spreadsheets for an RPG, each fine contains a dozen or so character sheets with identical formulae if I want to change one formula I have to then go through every player character and non-player Character sheet and paste in the new formula, is it possible to emulate Excel's Evaluate function?

for example, Formulas.B2 contains the formula =MID(CELL("filename",A1),FIND("$",CELL("filename",A1))+1,255) would it be possible to have something along the lines of =Evaluate(Formula($Formulas.B1)) that way only writing the formula once without having to make it a named expression it would also mean that canges to any formual will impact all sheets rather than one sheet at a time?