How to find a match in a part of the text in an Excel column and display cells where there are no matches?

Question

excel

How to find a match in a part of the text in an Excel column and display cells where there are no matches?
The first column is free text. In the second column, the desired piece of text.
We compare two columns and display lines where the desired piece of text is not present:
Masha loves Kolya. Masha Masha's ball fell Masha-masha
Masha38 We are looking for a match for the word Masha. Not found in the cells: Masha's ball fell Here is an example in the excel file https://yadi.sk/i/BoMiV0oW_spf_g

Answer 1

Search
Find