if x contains value excel code example

Example: excel if cell contains

"A"					"B"					"C"
"1"		Frog and duck       duck 				=ISNUMBER(SEARCH(B2,A2))

"C1" shows TRUE ('duck' is located at position 10 in "A1")