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 the 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 a case incentive function, use the SEARCH function.

11

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

BEST USAGE
1. To just know if a text is present in given 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

The FIND  function is excessively used with LEFT and RIGHT functions to extract specific texts. To learn in detail see this article.

Related Articles:

How to Use REPLACE function in Excel

How to Use SUBSTITUTE function in Excel

Excel SEARCH function

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

The VLOOKUP Function in Excel

COUNTIF in Excel 2016

How to Use SUMIF Function in Excel

 

Leave a Reply

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

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