How to Use FIND Function in Excel

The FIND function in Excel is used to find the location of specific text within a text. The FIND function return a number (which is first appearance of the searched text).
6
Syntax of FIND Function

=FIND(find_text, within_text, [start_num])
    • Find_text : The character or set of characters you want to find in string.

 

    • Within_text : The text or cell reference in which you want to find the text.

 

    • [start_num] : optional. The starting point of search.

FIND function example:
Just to explain FIND function better, I have prepared this data.
7
In Cell D2 to D4, I want to find the location of “Hero” in cell B2, “@” in cell B3 and “a” in B4, respectively.

I write this FIND formula in Cell D2 and drag it down to cell D4.

=FIND(C2,B2)

And now i have the location of the given text:
8

INFO:

    • FIND returns first found location by default.
    • If you want second found location of text then provide start_num and it should be greater than first location of the text.

9

    • If the given text is not found, FIND formula will return #VALUE error.

10

    • FIND is case sensitive. If you need an case insentive function, use SEARCH function.

11

  • FIND does not support wild card characters. Use SEARCH formula if need to use wild card to find text in a string.

BEST USAGE
1. To just know if a text is present in give cell or not.

12
Use ISNUMBER with excel FIND function.
ISNUMBER returns true if gets input as a number.
FIND returns found location as an whole number (integer).
2. To Trim TEXT using LEFT and RIGHT

Find is excevelly used with LEFT and RIGHT functions to extract specific texts. To learn in detail see this article.
So in this article we “found” the use of FIND function.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube