Previous Topic Next Topic

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.

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

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response