Saturday 9 January 2016

Re: [ ::: ♥Keep_Mailing♥ ::: ]™ Excel: Find vs Search Functions

Like

2016-01-09 17:18 GMT+08:00 Junaid Tahir <mjunaidtahir@gmail.com>:

​​


 

The FIND function and the SEARCH function are very similar to each other. This example shows the difference.

1. To find the position of a substring in a string, use the FIND function. FIND is case-sensitive.

Find Function in Excel

2. To find the position of a substring in a string, use the SEARCH function. SEARCH is case-insensitive.

Search Function in Excel

Note: string "excel" found at position 11. Even though it's actually the string "Excel"

3. The SEARCH function is more versatile. You can use wildcard characters when you use this function.

Asterisk

It also finds Microsoft Word 2010

Note: A question mark (?) matches exactly one character. An asterisk (*) matches a series of zero or more characters.

4. One other interesting point to mention about the FIND and the SEARCH function is that they have a 3rd optional argument. You can use this argument to indicate the position, counting from the left, at which you want to start searching.

Start Searching at Position 1

Note: string "o" found at position 5.

Start Searching at Position 6

Note: string "o" found at position 7 (started searching at position 6).


Source: excel-easy


--
You received this message because you are subscribed to the Google Groups "Keep_Mailing" group.
To unsubscribe from this group and stop receiving emails from it, send an email to keep_mailing+unsubscribe@googlegroups.com.
To post to this group, send email to keep_mailing@googlegroups.com.
Visit this group at https://groups.google.com/group/keep_mailing.
To view this discussion on the web visit https://groups.google.com/d/msgid/keep_mailing/CAG%3DbiTv7NaRy1UPFgzpx-RFucX3m8GV8ipVHMioCMCiQ89S%3Deg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Keep_Mailing" group.
To unsubscribe from this group and stop receiving emails from it, send an email to keep_mailing+unsubscribe@googlegroups.com.
To post to this group, send email to keep_mailing@googlegroups.com.
Visit this group at https://groups.google.com/group/keep_mailing.
To view this discussion on the web visit https://groups.google.com/d/msgid/keep_mailing/CAKe5fOWHY0qmoRgcg-BzweQDMHL5-kzwYVf%3DUX08-Bjzfdpzqg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment