Hello and welcome to our new video. In this video we are
going to learn about 5 formulas which are left, right,
length, find and the last one is mid.
Let's see how these 5 formulas work. First of all let's
open excel file. Here I have some data. I have some phone
numbers and some names. Now let's see what is left and
right formula.
Here I have 10 digits. If I count them, I will get some
length. For example, Rahul has 5 characters. If I count
space as a character, I will get 6, 7, 8, 9, 10, 11, 12, 13.
For example, if I count 7 as mid, I will get 8, 9, 9, 9.
For example, if I count 7 as left, I will get 8, 9, 9, 9.
First of all, we have to put sign of equals to because it
is a formula. We know that it is necessary to put equals to
in excel. Then I will write left.
Here it suggests me and I double clicked it. It is telling
me to write text. Now you can write text as well. Here it
is a number. So let's select it.
Here it is a number. So let's select it. Here it is a
number. So let's select it.
Here it is a number. So let's select it. Here it is a
number. So let's select it.
Here it is a number. So let's select it.
I want to search here tell me which number is a and what I
have written here in double quote I have written a and then
comma
I have selected it here what should be the answer ok after
this my last formula is length length tells me like here
what is the length length is 10 here if I talk about length
1,2,3,4,5 6,7,8,9,10,11,12,13 ok so what we have to do
equals to L,E,N double click tell me the text
I have written enter it tells me 10 if I drag it down
10,10,10 because these are phone numbers mobile numbers are
of 10 digit so here it tells me 13 let's count 10 1,2,3,4,5
6,7,8,9,10 clear if I count Jishan 1,2,3,4,5,6,7 13
2,2,4,6,7,8,9,10,11,12,13 I hope you understood how
left,right,mid and fine length works ok that's all you have
to do in this video practice and if you have any doubt then
play it again
I will meet you in next video