if text contains google sheets code example
Example: Google sheets How to Check if a Cell Contains a Substring
# Basic syntax using REGEXMATCH():
=REGEXMATCH(Cell#, "substring")
# Where REGEXMATCH returns TRUE if the substring is found in the Cell,
otherwise it returns FALSE
# Note, add =IF(above_or_below_expressions, 1, 0) if you want a numerical
TRUE/FALSE output
# Basic syntax using ISNUMBER(SEARCH()):
=ISNUMBER(SEARCH("substring", cell#, [starting_at]))
# Where:
# - SEARCH returns the position number of the first character in the
# first match, if found and ISNUMBER returns TRUE if search returns
# a number
# - substring is the substring that we're looking for
# - cell# is the cell containing the text that we're searching
# for substrings
# - [starting_at] is optional and is the character number at which to
start the search
# Note, SEARCH is not case sensitive