Returns the position at which a string is first found within text.
81% OFF online library of tutorials for mastering Google Sheets
SEARCH()
Description
How To Use in Sheets
SEARCH(search_for, text_to_search, [starting_at])
External Links
Text Search in Google Sheets
In this video, I demonstrate how to find instances where specific key words are present in cells, using Google Sheets. The formula that is used is: =IF(ISNUMBER(SEARCH("Text",Cell to Search)),"Text if found", "Text if not found")
2Better Sheets Tutorials
Learn to create a fun game called Hangman in Google Sheets with Better Sheets. Watch the video to challenge yourself and see how it works. What other games can you make inside of Google Sheets?
Create a game of hangman inside Google Sheets. Showcases a few Google Sheet formulas like SEARCH()
1
Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.
2