Microsoft Excel - Search - Search for multiple chars

=IF(ISNUMBER(SEARCH("*xyz*", A2)), 1, 2)
 
=ISNUMBER(SEARCH("an*", B17))

NOTE:

  • The * is a wildcard.