There is no direct function for substring search but you can use the REGEXMATCH() function to search if google sheets contains the desired text.