Find an specific text in a cell

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

My Office Excel is 2010, yours too?

=IF(ISNUMBER(SEARCH("MDA",A1)),1,0)

The error is at "MDA",A1 @Ron Coderre

=IF(ISNUMBER(SEARCH("MDA";A1;1));1;0)

I Just added a "1" after A1, changed some comas and it worked!

Thank your your help!! :D

Thx FDibbins, so simple but still so difficult!