One way.... If you download and install a free addin from here:

Then you can use this formula: Morefunc.xll

=EVAL(HYPERLINK(FORMULATEXT(A1)))