Find a cell's content in another cell but only as whole word(s)

[Paul]

cell text
a1 adam takes a walk
b1 dam take
b2 adam takes

What should I use in c1 and c2 to determine that b2 is within a1 as whole
words(TRUE) but b1 is not within a1 as whole words(FALSE)?

 

[Roger Govier]

Hi Paul

I haven't done exhaustive testing, but this seems to return the result you
want
=IF(ISERROR(EXACT(FIND(B2&" ",$B$1),FIND($B$1,$B$1))),FALSE,TRUE)

 

[Ashish Mathur]

Hi,

Try this

IF(OR(ISNUMBER(SEARCH(B1&"
",$A$1,1)),ISNUMBER(SEARCH(B1,$A$1,1)))=FALSE,"FALSE","TRUE")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com