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

Closed

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

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.

Match of Any word from one cell to other cell in excel
Number to text in word - Guide
Number to word in excel - Guide
Excel conditional formatting if cell contains specific text - Excel Forum
Excel formula to subtract one cell from another - Excel Forum
Transfer data from one excel worksheet to another automatically - Guide

1 response

Answer 1 / 1

Blocked Profile
Nov 1, 2017 at 06:41 PM

Does search work?

Try:
SEARCH(find_text,within_text)

Check out documentation here:
https://support.microsoft.com/en-us/office/search-searchb-functions-9ab04538-0e55-4719-a72e-b6f54513b495?ui=en-us&rs=en-us&ad=us

Similar discussions

How to use conditional format based on text?

help me to add particular cells

Counting cells containing only numbers

If a cell contains any text then add a value

How to convert the tamil pdf file to tamil word file

Similar discussions

Subscribe To Our Newsletter!