DAX search function

I wanted to try using seach within formula but have not been able t get it to work
as a test set up 2 column table, and then in the third column, in excel used search ;

Please Login or Register  to view this content.

In power pivot I tried the same in column ;

Please Login or Register  to view this content.

,
but this just give and Error,
I also tried find and again both work in power pivot but not in excel. I also tried in PBi but again got an error?

I have found that if I use ;

Please Login or Register  to view this content.

, but this is not much good if I want the positin of Cat and not Cow as well,

Richard.