You can use the REGEX formula in google sheets to find a substring in a string in google sheets.