I have cells that have phrases written in them. Now I wish to assign a value
to the corresponding cell in the next column if a particular word is present
in the phrase.

e.g. Column A Column B
Johnny Passed the exam If A1 contains Johnny,
write 1 else 2
Rita missed the train If A1 contains Johnny,
write 1 else 2

How do I achieve the formula for column B?
Thanks in advance.