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

Ask a question rock - Last answered on Nov 1, 2017 at 06:41 PM by ac3mark

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.
plus moins
Does search work?


Check out documentation here:

Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!