Thank you very much for your swift reponce. This sounds like the right
formula, but its just returning a number 16. I need it to say True if it
appears in the sentence, or a " 1" will do
--
Duncan


"antoka05" wrote:


if you need to know if the word present in cell A1 is in the cell B1
text you can put this formula in cell C1:
=FIND(A1,B1,1)


--
antoka05
------------------------------------------------------------------------
antoka05's Profile: http://www.excelforum.com/member.php...o&userid=29024
View this thread: http://www.excelforum.com/showthread...hreadid=487562