81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

SEARCH()

Description

Returns the position at which a string is first found within text.

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