excel if partial string match code example
Example: excel if contains partial text
"A" "B" "C"
"1" Frog and duck duck =ISNUMBER(SEARCH(B2,A2))
"C1" shows TRUE ('duck' is located at position 10 in "A1")
"A" "B" "C"
"1" Frog and duck duck =ISNUMBER(SEARCH(B2,A2))
"C1" shows TRUE ('duck' is located at position 10 in "A1")