SEARCH, SEARCHB function
Summary
Finds one text value within another (not case-sensitive)
Syntax
SEARCH(find_text,within_text,[start_num])
The SEARCH function has the following arguments:
• find_text Required. The text that you want to find.
• within_text Required. The text in which you want to search for the value of the find_text argument.
• start_num Optional. The character number in the within_text argument at which you want to start searching.
• find_text Required. The text that you want to find.
• within_text Required. The text in which you want to search for the value of the find_text argument.
• start_num Optional. The character number in the within_text argument at which you want to start searching.
Example
=SEARCH("e",A2,6)
=SEARCH(A4,A3)
=REPLACE(A3,SEARCH(A4,A3),6,"Amount")
=MID(A3,SEARCH(" ",A3)+1,4)
=SEARCH("""",A5)
=MID(A5,SEARCH("""",A5)+1,SEARCH("""",A5,SEARCH("""",A5)+1)-SEARCH("""",A5)-1)
=SEARCH(A4,A3)
=REPLACE(A3,SEARCH(A4,A3),6,"Amount")
=MID(A3,SEARCH(" ",A3)+1,4)
=SEARCH("""",A5)
=MID(A5,SEARCH("""",A5)+1,SEARCH("""",A5,SEARCH("""",A5)+1)-SEARCH("""",A5)-1)