Excel FIND Function

HomeExcel FunctionsExcel FIND Function (Example + Sample File)

What is EXCEL FIND FUNCTION

The Excel FIND Function is listed under Microsoft Excel's Text Functions category. It returns a number which is the starting position of a substring in a string. In simple words, with FIND you can find (case sensitive) a text string’s starting position from another string.

How to use it

To learn how to use the FIND function in Excel, you need to understand its syntax and arguments:

Syntax

FIND(find_text,within_text,[start_num])

Arguments

  • find_text: The text which you want to find from another text.
  • within_text: The text from which you want to locate the text.
  • [start_num]: The number represents the starting position of the search.

Notes

  • It is a case sensitive function.
  • You can refer to a single cell at a time.
  • You can also use Excel's wildcard characters (* ? ~) in it.
  • start_num should be a number 0 to the 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 to its starting point.

Example

To master FIND function we need to try it out in an example and below is one which you can try out:

In the below example, we have used the FIND to locate the “:” and then with the help of MID and LEN, we have extracted the name from the cell.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.