How to determine if a cell's text is part of another cell's text?

[teachman]

Hello,

I have two columns. Column A contains a chunk of text and column B contains a smaller chunk of text. I need to know if the text string in Column B is part of the text string in Column A.

Column A Column B Column C
The swift red fox jumped over the lazy brown dog. lazy Yes
The raven laughed at the sight raven laughed Yes
Laughing echo was heard in the canyon valley No

I'm hoping there is a way to compare Column B to Column A and if the compare is TRUE (column B text string was found in Column A text string) then the result (Yes or No) is put in Column C.

Any ideas?

Thanks,

George Teachman

 

[louisH]

Hi,

=IF(SUBSTITUTE(A1,B1,"")<>A1,"Yes","No")

 

[Joe4]

Try this formula in C1:

=IF(ISNUMBER(SEARCH(B1,A1)),"Yes","No")