View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default 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)?