In Google Sheets, the SEARCH function works by searching for a specific substring within a single text value. You simply provide the substring you want to search for, along with the text string you want to search within, and the function will return the position of the substring if it is found.