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")

0Better Sheets Tutorials

No videos yet. Stay tuned!