Regexpfind and queire in URL

Support
#1

I have a question about RegexpFind.

If we have a text in A1 for exemple "deux-regions-en-cole" and in B1 we have a url "http://www.domaine.fr/actualites/region/deux-regions-en-colere-contre-la-marque" which formula do you use to search A1 in B1 and if A1 is present in B1 so display B1 in C1.

Any idea about this. Is it possible with RegexpFind.

#2

How about this:

   =RegexpFind(B1,".*"&A1&".*",0)

Pasted image1345×581 55.1 KB

#3

Yes it's perfect. thanks