« College World Series
Classes: CommandBarButton Events »

SEARCH And FIND

18th June 2004, 08:22 am by Dick Kusleika

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

Category: Worksheet Functions  |  Comment (RSS)

One Comment

  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.

    22 June 2004, 11:26 am

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment