SEARCH and FIND Function in Excel
hi in this video we want to learn sets and find functions these two functions
are pretty similar the only difference between them is case sensitivity these
two functions find a letter position in the string in a phrase in a sentence and
show it as a number that we will find it in practice the only difference between
them is case sensitivity as I told you it means it find function we have case
sensitivity that we don't have it in search function let's practice
search one in this case we want to find the lower case one in the string G three
because as you see we search put D lower case but it's said one that it's the
position of first D in the derecho site knowledge because it's not case
sensitive now you want to use exactly this formula in find function and let's
see what will happen the lower case G 3 as you see it's 20 that it shows the d
of knowledge and if you count it from first you will find it's the its
position is 280 just the consider spaces as tractors because there are characters
then you want to count it you have considered spaces to fix one wanna find
o in the echo site knowledge by search function letter O in g3 calculus it's
number six in there one two three four five six now you want to insert a start
position in orphan to see what will happen here again
search function function we want Oh exactly same letter in same address g3
but here we will exert their we want to start searching okay I put seven so it's
really just ignore or up the uncle you see in sixteen because the next Oh is
all of knowledge and in its position is sixteen last situation is men we want to
search for a word instead of letters if we search for this one site in the echo
site knowledge the number that we will have is the number is the number of the
position of the first letter in that world it means it so just consider s not
side let do it search we want side or we can to simply put its address its h7 and
then G 300 you see it's eight of course it's not to it because it's not count
words it count letters and the first letter here is s that its position is
eight in order to watch more training videos please subscribe to our YouTube
channel Diablo te and if you want to see your products please visit our website
Yahoo dot uk'