If cell A contains text from Cell B

[dibblejon]

Hi

Can someone please help me with this I expect simple scenario for you guys!

I am trying to return a true, false dependant on whether a Cell contains text from another cell.

Example:
Column A
423444-21 WOFFICE
424466-33 ZZ/1
425466-32 W/12

Column B
WOFFICE
WOFFICE
W/12

So I would like to get the results:

True
False
True

The data has not always been entered as uniformally as this which is why I need to to a 'if contains' search.

Any help would be great, thanks.

 

[VoG]

Try

=ISNUMBER(FIND(B1,A1))

 

[dibblejon]

Great thanks.