Hi,

Am Wed, 6 Jun 2012 13:33:18 -0700 (PDT) schrieb cardan:

Your formula returns the value in the cell. I am looking for it to return the last 2 characters in the formula. RIGHT, LEFT, MID, FIND, deal with texts within the cell value(output). I need it to look at the "text" of the formula.

you have to do it with VBA:
With Sheets("sheet2")
.Range("A2") = Right(.Range("A1").Formula, 2)
End With


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2