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

Posting code or formulas in your comment? Use <code> tags!

  • <code lang="vb">Block of code goes here</code>
  • <code lang="vb" inline="true">Inline code goes here</code>
  • <code>Formula goes here</code>

Leave a Reply

Here's how to update your reports of company and nearly any web data: