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

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)?

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

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)
--
Regards
Roger Govier

"Paul" wrote in message
...
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)?

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

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Paul" wrote in message
...
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)?