Report

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
Hello,



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

Try:
SEARCH(find_text,within_text)


Check out documentation here:
https://support.office.com/en-us/article/SEARCH-SEARCHB-functions-9ab04538-0e55-4719-a72e-b6f54513b495

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!