Match of Any word from one cell to other cell in excel

rock - Nov 1, 2017 at 06:31 AM
 Blocked Profile - Nov 1, 2017 at 06:41 PM

I have a data in which I need a any match that contains in the other excel cell

For example I have a data Like in one cell i have "MASTISOL LIQUID ADHESIVE 2/ Surgical 3CC " and other cell I have "SURGICAL MASTISOL 1 2OZ LIQUID" in this the match is " Surgical"

I want to match the word form one cell to other cell.

and the length is viery from each cell.

Please help me out.

1 reply

Blocked Profile
Nov 1, 2017 at 06:41 PM