Will this work?
=RIGHT(D4,LEN(D4)-FIND(123,D4)+1)

--
Don Guillett
SalesAid Software

"Fish" wrote in message
...
Is it possible to code a find to determine if any part of
a value is in a text for instance:

=RIGHT(cell,3) xxx123 gives 123

is it possible to just code to find 123 in a text