Look at below example. In B2, we have '=FIND("JOHN", A2)' formula that returns '#VALUE' as FIND couldn't find the exact value ('JOHN') in A2 cell. (FIND is case-sensitive function).
No support for wildcard characters
Look at below example, we are trying to find 'J?hn' where I am looking for any character in place of '?'. FIND gives '#VALUE' error.
When we pass the same parameters in SEARCH function, we get '1'. So our formula in C2 is '=SEARCH("JOHN", A2)'. As SEARCH function is case-insensitive, as long as text to find is same (either upper or lower or mixed case), it returns the position of the text found in A2 cell.
See the similar examples below for FIND
Support for wildcard characters
SEARCH function supports wildchard characters, you can see that 'J?hn' parameter still in SEARCH still returns '7'.
Can we also use '*' wildcard character instead of '?' - YesViews: 3891 | Post Order: 29