How to use Excel FIND Function in Office 365? – Simple Ways!!
Tags: excelfunctions, findfunctioninexcel, excel, exceltutorials
Published: 2020-12-14 12:20:23

---
title: How to use Excel FIND Function in Office 365? – Simple Ways!!
published: true
date: 2020-12-12 05:40:30 UTC
tags: ExcelFunctions,FINDFunctioninExcel,Excel,ExcelTutorials
canonical_url: https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/
---

## FIND Function in Excel:

Find is nothing but search for something we want. Excel also provides this search feature as a Function called FIND. Using this function, we can easily get the data we want from the current worksheet.

Here, we will explore the basic syntax and usage of the **FIND function** in **Excel Office 365** with some examples.
## **Explanation of the FIND Function:**

- The Excel FIND function is used to **find out the one text string** inside the other.
- This function will find out the **location of the text and returns the position as a number**.

## Primary Syntax of FIND ** Function** :

The Primary syntax of Excel **FIND**  **Function** is,

```
**=FIND(find\_text, within\_text, [start\_num])**
```

### Argument Explanation:

- **Text:** Get the location of text in a string

## **FIND Function – Practical Examples:**

**Example 1:**

- Enter the input text in the **cell C6.**
- The below **Formula** will help you.

```
**=FIND("A",C6,1)**
```

- Here the **“A”** → find\_text, **“C6”** → within\_text, and the **“1”** → start\_num (optional).

![Using formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_2-28.png)<figcaption id="caption-attachment-4630">Using formula</figcaption>

- In the above screenshot, I want to find the letter **“A”** from the text string of **“BINARY DOCKS”.**
- Using the FIND formula, we are going to find the **location of the letter “A”** and display the **result as a number.**
- Press **Enter** to display the **Output** in **Cell E6.**

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_1-31.png)<figcaption id="caption-attachment-4627">Output</figcaption>

**Example 2:**

- The below screenshot is another example of **FIND Function.**
- The procedure to enter the output are the same as we have followed in the above example.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_4-25.png)<figcaption id="caption-attachment-4675">Example 2</figcaption>

- In the FIND Function, **space** is also considered as a **number**.
- In this example 2, you can refer to the screenshot that the location of the **“F”** displays the output as **“7”** because space also added as the count in calculating the position.

## Verdict:

We hope that this tutorial explained to you clearly about the use of the **FIND**  **Function** in Excel with some practical examples. If you have any **queries/doubts** , kindly share them in the below comment section.

Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!

## Related Articles:

- **[TODAY Function in Excel](https://geekexcel.com/how-to-use-today-function-in-excel-365/)**
- **[CLEAN Function in Excel](https://geekexcel.com/how-to-use-clean-function-in-microsoft-excel-365/)**
- **[RIGHT Function in Excel](https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/)**
- **[WORKDAY.INTL Function in Excel](https://geekexcel.com/how-to-use-workday-intl-function-in-excel-365/)**
- **[EDATE Function in Excel](https://geekexcel.com/how-to-use-edate-function-in-excel-365/)**
- **[UPPER Function in Excel](https://geekexcel.com/how-to-use-upper-function-in-microsoft-excel-365/)**
- **[EOMONTH Function in Excel](https://geekexcel.com/how-to-use-eomonth-function-in-microsoft-excel-365/)**
- **[YEAR Function in Excel](https://geekexcel.com/how-to-use-year-function-in-excel-365/)**