There are two functions that look for text within text, SEARCH() and FIND(). The only difference between the two is that SEARCH() ignores case, while FIND() does not. The syntax for both functions is

FUNCTION(short_string, long_string, start_number)

Here’s are some examples that demonstrate the case issue.



  1. Jonathan Rynd says:

    That’s not correct, there’s another difference — SEARCH supports wildcards *, meaning any string, and ?, meaning any character, while FIND does not.

  2. Manish Chopra says:

    Search does not support wildcards characters like ?,* while find does

  3. […] FIND and SEARCH functions in Excel are substantially similar. Their purpose, as you may imagine from their names, is to find a particular piece of text within a text […]

Posting code or formulas in your comment? Use [cc] tags!

  • [cc_vb]Block of code goes here[/cc_vb]
  • [cci_vb]Inline code goes here[/cci_vb]
  • [cc]Formula goes here[/cc]

Leave a Reply