*PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES*

#### CONTENTS

# EXCEL FUNCTION-FIND

## INTRODUCTION

*FIND FUNCTION is one of the very important and useful functions in Excel.*

*As FIND FUNCTION is concerned with the text, it is present under the TEXT FUNCTION CATEGORY of the functions.*

FIND FUNCTION FINDS THE POSITION OF A CHARACTER OR ANY TEXT FRAGMENT INSIDE ANOTHER TEXT AND RETURNS THE STARTING CHARACTER’S LOCATION AS THE POSITION.

*FIND FUNCTION counts the characters whether it is single byte or double byte. [Byte is the size of the characters].*

*It finds out the exact same copy of the characters or text to be searched. It compares content as well as case of the text.*

*FIND FUNCTION is quite useful in manipulating text to get the desired results easily. *

*In this article we would learn about the purpose, syntax, formula of the FIND FUNCTION and get a better understanding with the help of the examples.*

## PURPOSE OF FIND FUNCTION IN EXCEL

**FIND FUNCTION is used to find any character or text fragment within a longer text and return its starting position as the character number. **

For examples,

Suppose we need to find the location of any character or text pattern in the given text.

Let us take a text snippet ” **What a beautiful day!**“

Now if we want to find the location of the first ‘a’ or the word ‘beautiful’, we can do so with the use of the **FIND FUNCTION**.

## PREREQUISITES TO LEARN FIND FUNCTION

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the TEXT HANDLING IN EXCEL is an advantage for the use of such formulas.
- Of course, Excel software.

## SYNTAX: FIND FUNCTION

**The Syntax for the FIND function is**

**=FIND ( TEXT TO BE FIND, TEXT IN WHICH THE TEXT IS TO BE FOUND, STARTING CHARACTER POSITION FOR THE SEARCH)**

**TEXT TO BE FIND**is the character, text, word or pattern which we want to find

**TEXT IN WHICH THE TEXT IS TO BE FOUND**is the longer text in which we want the first argument to be found.

**STARTING CHARACTER POSITION FOR THE SEARCH**is the starting position from where we’d start our search. All characters before this position will be ignored.

FIND FUNCTION IS CASE SENSITIVE. IT’LL FIND EXACTLY WHAT IS IS ASKED FOR INCLUDING THE CONTENT AND THE CASE OF THE TEXT.

**TEXT TO BE FIND**is “ap”

**TEXT IN WHICH THE TEXT IS TO BE FOUND is**“Happy”

**STARTING CHARACTER POSITION FOR THE SEARCH**is 1 as we want to start the search from the first letter.

## EXAMPLES:FIND FUNCTION IN EXCEL

### EXAMPLE TYPE 1: FINDING A LETTER [FIRST OCCURRENCE]

Let us take a word say “GOOD MORNING”.

Let us try to find out the position of ‘G’, space, ‘I’.

**STEPS TO FIND OUT THE POSITION OF THE CHARACTER IN THE GIVEN WORD:**

- Select the cell where we want the result.
- Enter the following formulas for G , space and I in the given word.
- For finding the G, put the formula as
**=FIND(“G”,E6,1)** - For finding the ” ” SPACE, put the formula as
**=FIND(” “,E7,1)** - For finding the I, put the formula as
**=FIND(“I”,E8,1)**

### EXAMPLE TYPE 2: FINDING A TEXT PATTERN IN THE GIVEN TEXT

Let us take a sentence ” Humpty Dumpty sat on a wall”

Let us try to find out the pattern ‘pty’ in the given sentence.

**STEPS TO FIND OUT THE POSITION OF THE PATTERN IN THE GIVEN SENTENCE:**

- Select the cell where we want the result.
- Enter the following formulas for finding “pty”.
- For finding the G, put the formula as
**=FIND(“pty”,E20,1)** **Click**Enter.- The result would appear.
- The picture below shows the result and other details.

**EXPLANATION:**

Let us understand the working of the formula.

We used the formula =FIND(“pty”,E20,1)

Where the first argument “pty” is the one which we want to find.

E20 contains the complete sentence in which we want to find the occurrence position of this pattern

Third argument is 1 which tells us that we want to start the search from the position 1.

Now, we might have a thinking that there are two occurrences of “pty” in the sentence. What if we need the second occurrence.

Well, there is no direct function for finding out the second occurrence but we can use a trick to find one.

The next example is the extension to this one and finds out the second occurrence of “pty”

### EXAMPLE TYPE 3: SEARCHING THE TEXT PATTERN AT THE SECOND POSITION

Let us take a sentence ” Humpty Dumpty sat on a wall”

Let us try to find out the second occurrence of the pattern ‘pty’ in the given sentence.

**STEPS TO FIND OUT THE POSITION OF THE SECOND OCCURRENCE OF THE PATTERN IN THE GIVEN SENTENCE:**

- Select the cell where we want the result.
- Enter the following formulas for finding the second occurrence of the pattern “pty”.
- For finding the G, put the formula as
**=FIND(“pty”,E29,FIND(“pty”,E29,1)+1)** **Click**Enter.- The result would appear.
- The picture below shows the result and other details.

**EXPLANATION:**

Let us understand the working of the formula.

We used the formula **=FIND(“pty”,E29,FIND(“pty”,E29,1)+1)**

**FIND(“pty”,E29,1)**returns the position of the first “pty” in the given text. Now if we start the search after this position,

## KNOWLEDGE BYTES

### DIFFERENCE BETWEEN FIND FUNCTION AND SEARCH FUNCTION

OTHER WAYS TO REACH THIS ARTICLE

## WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

YOU MAY LIKE

- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.