FIND and SEARCH function :

FIND function syntax:

FIND(find_text, within_text, [start_num])


SEARCH function syntax:

SEARCH(find_text, within_text, [start_num])

Note:- Start_num is optional, if you omit start_num, it is assumed to be 1.

The Excel FIND and SEARCH function , enables you to finds a substring within another text string and returns the starting position of the substring. start_num argument is optional, it is for you to specify the character position at which to begin searching.

Now, what makes the two function different:-
FIND function is case-sensitive and don't allow wildcard characters. Whereas SEARCH function is NOT case-sensitive and allow wild card.

Examples:-
=find("s", "Seeing is believing")
Result : would be 9 .

=search("s","Seeing is believing")Result : would be 1 .

=find("s","Seeing is believing",7)
Result: 9

=search("s",Seeing is believing",7)
Result: 9

=find("worship", " work is worship")
Result: 9

=search("worship","work is worship")
Result: 9

=search("?!", "Ah! Have they gone?")
Result : 2

=search("!?","Ah! Have they gone?")
Result : 3

=search("~?","Ah! Have they gone?")
Result : 19