builtin worksheetfunctions can't work with the formula in a cell. You would
need to write a UDF in VBA.

--
Regards,
Tom Ogilvy

wrote in message
...
Hello,

Is it possible to tell what the right 3 characters in a
formula are

I am familiar with =Right(a1,3)

but how do I get this to work with the formula in the cell
not the value that ends up in the cell