How to identify if text is a subset of another text from separate field

[tushar_Kumar_bain]

Hi there,

I've been trying to find if the text in the cell of column H is a subset of the corresponding cell of column C. Is there any way to automate this?

Also while solving this problem, please be mindful to carefully observe how the text IS and ISN'T a subset by referring to the sample image and data.

Thanks!!

[atcodedog05]

Hi @tushar_Kumar_bain 

Here is how you can do it. You can check subset with help of contains() function.

Workflow:

Hope this helps : )

[Qiu]

@tushar_Kumar_bain 
or we can try the find and replace tool.