Finding a word and replacing it with a number

[Bitteeinbit]

Hi,

So assuming I have a list of sentences in column A. In column B, I now want to enter either the number 1 if the sentence in the same row contains the word "horse" or the number 2 if it doesn't. I can't seem to figure out what formula to use.

=if(A1="horse", 1, 2)
But obviously this won't work because the sentence never contains simply the word "horse", It'll have "horses on parade" or stuff like that. vlookup or hlookup won't work either as far as I know.

How can I get around this?

Thanks in advance,

-B

[martindwilson]

=IF(ISNUMBER(SEARCH("horse",A1)),1,2)

[Bitteeinbit]

Amazing! Much appreciated.