Pinterest Pixel

FIND Formula in Excel

  What does it do? Gets the position of a specific text within another text Formula breakdown:... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

 

What does it do?

Gets the position of a specific text within another text

Formula breakdown:

=FIND(find_text, within_text, [start_num])

What it means:

=FIND(text to be searched, the source text, [starting position of the source text])


If you want to check where a specific text is located in the source text, it is very easy to search for the position using the FIND Formula!

You need to take note that the FIND Formula is case-sensitive when searching for your text! And it always matches the first occurrence. We will see in our examples below!

I explain how you can do this below:

FIND Formula in Excel | MyExcelOnline

Download excel workbookFIND-FORMULA.xlsx

STEP 1: We need to enter the FIND function in a blank cell:

=FIND(

FIND Formula in Excel

 

STEP 2: The FIND arguments:

find_text

What is the text to be searched for?

Select the cell containing the text to be searched for. In our first example, we want to search for ‘x’ in the word ‘Excel’:

=FIND(D9,

FIND Formula in Excel

within_text

What is your source text?

See also  TYPE Formula in Excel

Select the cell source text. So let’s select ‘Excel’ as our source text:

=FIND(D9, C9,

FIND Formula in Excel

start_num

Where do you want to start searching in your source text?

You can leave this blank, it will default to 1 which means it will start looking from the first character of your source text. In our case, let us put in 1 to start searching from there:

=FIND(D9, C9, 1)

FIND Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

FIND Formula in Excel

You can see that the matching is case sensitive! And if it’s unable to find your text, it will return #VALUE.

FIND Formula in Excel

 

How to Use the FIND Formula in Excel

 

 

SORT Formula in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

See also  CountIf Formula in Excel
FIND Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!