Hello Everybody,

It's my first time in a Forum, and after looking around in different forums (and not finding the answer) i'm finally here asking for some help.

I want to be able to find a specific text in a cell, and i've found several explanations, but not for my problem.

The example:

My cell has the following information:

"0-IMDA046_Article (example) PACE->EPS" all that in just one single cell

I want to be able to search inside this cell the text "MDA" and if the cell contains this text the answer is 1, otherwise it's empty or 0.


I've tried: =IF(ISNUMBER(SEARCH("MDA",A1)),1,0)

This was the closest i could get

Could someone help me?


Thank you

Leandro