# Excel FIND Function

Home ➜ Excel Functions ➜ **Excel 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.

**Hey Listen,**

This is a complete guide to help you to understand Microsoft Excel Basics and other important things, and once you do that, you can learn some Advanced Excel Tricks to get smarter in your daily work.

## 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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

COPYRIGHT © 2020 • EXCEL CHAMPS