How to use the FIND function in Excel
How to use the FIND function in Excel
Learn how to use the FIND function in Microsoft Excel. This tutorial demonstrates how to use Excel FIND with four easy to follow examples and takes you step-by-step through the different options when entering your formula.
FIND Function (and sample data):
https://www.techonthenet.com/excel/fo…
Excel Functions/Formulas:
https://www.techonthenet.com/excel/fo…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0.03 -> FIND is one of the most useful
string functions in Excel
4.308 -> If you want to find the location
of a substring in a string
8.18 -> the FIND function is great to use
10.84 -> To illustrate how the FIND function works,
let's look at some examples
15.4 -> In column A, we've listed string values
that we wish to search
19.9 -> In column B, we have the substring that we want
to search for in each of those strings
25.18 -> In this tutorial, we are going
to cover four different examples
28.88 -> that demonstrate how the FIND function works
31.46 -> and show you how it performs
a case sensitive search
34.7 -> To get started, let's begin by entering the
FIND command
38.868 -> As you can see, the FIND function
takes three parameters
42.88 -> The first parameter we will need to enter
is the substring that you want to find
47.6 -> This parameter can either be a value or
the reference to a cell that contains a value
53.6 -> In our example, we will enter cell B2 which contains
the value "T" in uppercase
60.02 -> The second parameter we will need
to enter is a string to search within
64.5 -> Again, this parameter can either be
a value or the reference to a cell
68.68 -> In our example, we will enter cell A2
which contains the value "TechOnTheNet"
74.36 -> The third parameter is optional
76.872 -> It is the position in the string where the search will start
80.38 -> The first position in the string is 1
83.08 -> In this tutorial, we will skip this parameter
85.7 -> and let the FIND function perform
the search at the beginning of the string
89.38 -> We will cover how to use
the start position parameter in a future tutorial
93.86 -> Now let's complete the command
and look at our results
97.62 -> You should see the value 1
appear in cell D2
101.3 -> In this example, the uppercase "T" character was found
in the first position of the string "TechOnTheNet"
107.94 -> Now let's copy our formula down to
cell D3 to D5
112.52 -> In cell D3, the FIND function found
the lowercase "t" character
117.08 -> in the 12th position in the string "TechOnTheNet"
120.44 -> which demonstrates that the FIND function
performs a case-sensitive search
125.16 -> It ignored the uppercase "T"
in positions 1 and 7
128.98 -> and returned the position of the lowercase "t"
in position 12
133.1 -> In this next example, we are searching
for the string "The"
137.12 -> When you search for a substring
that is more than one character long
140.92 -> the FIND function will return the position of the
first character of the substring when it finds a match
147.28 -> In this case, the FIND function returns 7
150.38 -> which is the first position of
the substring "The" in the string "TechOnTheNet"
154.84 -> And finally, in our last example,
we want to show you what the FIND function will return
159.44 -> when no match is found
161.74 -> Since the character "Z" is not found in "TechOnTheNet",
the FIND function will return the #VALUE! error
168.9 -> This covers a few basic examples of
how to use the Excel FIND function
173.82 -> If you would like to see more examples
175.96 -> or would like to download the
sample data we used for this tutorial
179.4 -> please visit our website
at TechOnTheNet.com
183.063 -> If you found our tutorial helpful,
please leave a like on this video
186.96 -> and don't forget to subscribe to our YouTube channel
for more great Excel tutorials
Source: https://www.youtube.com/watch?v=NVeAPVP8zWg