google sheets how to check if a cell contains a substring

1# Basic syntax using REGEXMATCH():
2=REGEXMATCH(Cell#, "substring")
3
4# Where REGEXMATCH returns TRUE if the substring is found in the Cell, 
5	otherwise it returns FALSE
6    
7# Note, add =IF(above_or_below_expressions, 1, 0) if you want a numerical
8	TRUE/FALSE output
9
10# Basic syntax using ISNUMBER(SEARCH()):
11=ISNUMBER(SEARCH("substring", cell#, [starting_at]))
12
13# Where:
14#	- SEARCH returns the position number of the first character in the 
15#		first match, if found and ISNUMBER returns TRUE if search returns 
16#		a number
17# 	- substring is the substring that we're looking for
18# 	- cell# is the cell containing the text that we're searching
19# 		for substrings 
20# 	- [starting_at] is optional and is the character number at which to
21		start the search
22
23# Note, SEARCH is not case sensitive