Home ► Excel Function ► Excel Find Function

Syntax For Excel FIND Function

What is the use of Excel FIND Function

Use Excel Find Function to locate the position of a text string from another text string. By using this function, you can find a single character as well as a complete word from a text string. It will return the starting position of a text string in another text string.

Syntax for Excel FIND Function

FIND(find_text,within_text,[start_num])

find_text Text string which you want to find from the another text string. find_text can be a single alphabet or a word. [Required]

within_text Text string from which you want to locate the text. You can refer to a cell, or you can input a text in your function. [Required]

start_num A number represent the starting position of the search. [Optional]

More Information on Excel FIND Function

  • It is a case sensitive function. You can use the search function if you want to search for a non-case-sensitive text.
  • You can refer to a single cell at a time.
  • You can also use wildcard characters (* ? ~) in it.
  • start_num should be a number between 0 to max length of the text string from which you want to find your text.
  • When you are searching for a whole word from another text string, it will only return its the starting point.

Examples to understand Excel FIND Function

Extract a Text With Excel Find Function

Get The Starting Position of a Text With Excel Find Function

In above example,

we are searching for alphabet “well” and we have specified start_num as 1 to start our search. Our formula returns 12 as the position of the text. And, if you look at it, the word “well” starts from the 12th position in the text string.

Use Excel Find Function With MID Function

Now, in above example, we have used the find function to locate the “:”. And, then with the help of MID Function & LEN Function, we have extracted the name from the cell.

You can also use it to create dynamic formulas in your worksheet.

Download More Useful Tips On Excel Find Function

Conclusion

You can use Excel Find Function to play well with your textual data. If you are interested in case-sensitive search, you can use find function for finding a word in a cell. Learn more about how to use excel find function from here.

Related Function

Right | Len

Blog | Excel Functions


  • Jaderson Almeida

    Hello, good morning! Very nice explanation! Congrats! Keep up your great job.

    • Puneet Gogia

      Hey Jaderson.

      Thanks for your words.