SEARCH And FIND

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.

FindSearch

3 thoughts on “SEARCH And FIND

  1. Jonathan Rynd

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

  2. Pingback: Step-by-Step Tutorial: How to Use the LEFT, RIGHT, MID, LEN, FIND and SEARCH functions in Excel - Power Spreadsheets

Leave a Reply

Your email address will not be published. Required fields are marked *

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see http://daringfireball.net/projects/markdown/syntax