How to check whether one cell of the column contains any one cell of one column data

[cyg3003]

I've met one problem, which is how to check whether one cell of the column(pic 1）contains any one cell of one column data(pic 2) 

the results are supposed to be like below:

ABCDEET OPS_DE    returns    OPS  
CFDSET SE                returns    SE
IF KE SI                       returns    NO_MATCH

the sample data is provided below.

Will appreciate your help

Thanks

Molly

[PhilipMannering · Accepted solution]

Hi Molly,

This solution using the Find and Replace appears to work for your example...

[cyg3003]

thanks!!!!  it does work😍

[PhilipMannering]

Glad to hear it! :) This is why the Find Replace is one of my favorite tools.