Returns the position at which a string is first found within text.
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")
0Better Sheets Tutorials
No videos yet. Stay tuned!