Difference between Search and Find Function ?

Ans :  

A) Find :

The FIND function in Excel is used to return the position of a specific character or substring within a text string.

The syntax of the Excel Find function is as follows:

FIND(find_text, within_text, [start_num])

If the FIND function does not find the find_text character(s), a #VALUE! error is returned.

For example, the formula =FIND("d", "find") returns 4 because "d" is the 4th  letter in the word "find". 

The formula =FIND("a", "find") returns an error because there is no "a" in "find".

B) Search :

The SEARCH function in Excel is very similar to FIND in that it also returns the location of a substring in a text string. Is syntax and arguments are akin to those of FIND:

SEARCH(find_text, within_text, [start_num])

FIND and SEARCH functions in Excel are very much alike in terms of syntax and uses.

However, they do have a couple of differences.

A) Case-sensitive FIND vs. case-insensitive SEARCH :
The most essential difference between the Excel SEARCH and FIND functions is that SEARCH is case-insensitive, 

while FIND is case-sensitive.

For Ex :

=SEARCH("e", "Excel")

returns 1 because it ignores the case of "E", while

=FIND("e", "Excel")

returns 4 because it minds the case.

B) Search with wildcard characters :
Unlike FIND, the Excel SEARCH function accepts wildcard characters in the find_text argument:

A question mark (?) matches one character, and An asterisk (*) matches any series of characters.