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
Solucionado! Ir para Solução.
thanks!!!! it does work😍
Glad to hear it! :) This is why the Find Replace is one of my favorite tools.