Search for specifc text in a cell and return 1 if found

[Maxme]

Hello I have Text that I want to search in a cell and return a 1 if found. Basically have little league baseball kids that are picthers with the word Loss or Win a cell and if they have either return 1 for that day.

The Cell Looks like like for example

Pitcher Win Loss
John Doe (Loss, 0-1)
John Doe2 (Win, 1-0)

So for So if you won add 1 and if you lost add 0

- Thanks Max

 

[Richard Schollar]

Hi Max

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

 

[Aladin Akyurek]

=ISNUMBER(SEARCH("Win",A2))+0