hello and welcome to our new video
in last video we have seen some formulas
which were
left, right
length, find
and mid
now there we have seen a problem
when we were using left or right formula
so the names were
coming after cutting
so we are going to solve this problem
in this video
so first of all let me open excel file
you also have to open excel file
and here I have some data
serial number of some students
10 students
their names are written here
here left formula is there
right formula is there and length is there
now all these names which are given to me
their length can be different
so first let us find length
so for length we know
what formula is used
so I have to put sign of equals to
and here I have to write len
after writing this much
so what we have to do
we have to double click here
and tell me
in parameter or argument
what I have to put is tax
now this tax is
this one
because we have to find length of name
by the way we can count it
from here also
1,2,3,4,5,6
we have seen in last video
that we can count space also
so what happened with space
then 7,8,9,10
11,12,13
so what is
length of this name
will be 13
so let us select it from here
and close bracket
now if I enter
what should I get? 13
rest of all
let us see length of name
so we will know
that length is varying
so what we do
let us drag it down
and we get
length of Imran khan
is 10
jishan rahmani
is 15
12 and 11
so one thing is clear
that length is different
now left formula
which we have used
we have written equals to
left and here it suggests
that we have to double click
and I have to write text
so I have taken text from here
and after that
I have put comma here and it is telling me
number of characters
number of characters means
how many characters you want from left side
so I said give me 4 characters
or give me 3 characters
whatever you want to write
you can write
and I enter
so it is here
and if I drag it down
so what will happen
it will show me 4 letters
of any name
but if I use right one
and I say from here
that I have to use equals to right
formula
I have written right here and it suggests me
I have double clicked it
here it is asking me for text
same thing will come in text
so I have selected name from here
after that it is asking
number of characters
and it is asking from right
hand side
so I said give me
5 characters from right hand side
so I have written 5 characters
and I have entered
so it is here
and if I drag it down
so it is here
so what we want is
before space
we want proper name
we don't want proper name
if length is varying
so it is not good
so what we have to do
when we use left formula
so we want
before space
Rahul name
before space
Rahul name is 5
Shivam is 6
so here if I
use left formula
so it is different
we want
before space
it doesn't matter
we want proper name
we don't want proper name
so what we have to do
we will do simple
I will delete it
so we will get
Rahul name
Rohila name
before space and after space
but here we have to do
we have to use two formulas
in last video we saw
when we were using find formula
we saw the number of space
we can find it
so here we have to use
two formulas
first left formula
we have to use
find formula
so let's see how to do it
so for left
we have to write
left
we have to double click
what we have to put here
text
so I selected text
now when you ask me in other argument
number of characters
so I don't want to put here
what I have to put here
I have to put formula
so what I want
where I get space
before that show me
here we are not putting character
we have to put here
where you get space
before that
whatever it is
it doesn't matter
give me full name
so I will do here
I will write find
after that it suggest me
double click
what you want to find
so I said
I want to find space
before that
whatever it is
give me
second argument is within the text
I will put comma here
where we have to find this space
we have to find this space
in this name
after that I
closed the bracket
this bracket
this is one bracket
we have to close this
so we closed this bracket
after that what I have to do
just enter
see full name
before this space
all characters
so now what will happen
name length
name length is 7 characters
here 6 characters
here also 6 characters
so now what will happen
now whatever name is
left side
before this space
I should get all
drag
or you can double click
I will show you again
like this
Rahul name
we have to apply same formula
on all other cells
you have only one option
you can drag like this
if you don't want to drag like this
you can double click
on this plus sign
and all other cells
will be filled
and formula will be applied
now let's talk about right formula
I want
right hand side
surnames
their length is also different
Rohila has 7 characters
Khan has 4 characters
Mishra has 6 characters
here also length is varying
so I want
I want all characters
on right hand side
now how to do
we have used two formula on left
here we will use three formula
so we have to do
as we do in right
first we have to write equals to right
see it suggest us
now you will see
what all argument it ask
first you have to give me text
I said ok
next is number of characters
here we will not use
number of characters
we will use three formula
first is right
second is find
third is length
so what I have to do
I have to reduce space from length
this is what I have to do
first
number of characters
here I will use length formula
and I know
what we have to write
L E N
now we want to find length
we want
to find length of
whole name
now what we have to do
we have to close this bracket
so from length formula
we have to minus
find
so we will do simple
we will write minus
double click
and ask me
find text
what we have to find
we have to find space
double quote
comma
within the text
which text we have to find
we have to find in this
we have to close this bracket
remember this bracket
otherwise formula will be wrong
it will not give any result
I forgot to close this bracket
if I forgot to close this bracket
then what will happen
I will enter
we found a typo
in your formula and try to correct it
we got it
that what mistake you have done
we want to correct it
so what he did
he put this bracket
however
if you forget it, it will suggest us
but you have to remember
that all the brackets you open here
you will close it
so I enter it here
and see this full name came
after space
after this all these things
I make it simple
double click and see
now my name is not missing
my surname is not missing
Rahul, Imran, Jishan
see here
Rohila Khan, Rehmani, Mishra, Kumar
nothing is missing
so we saw that in last video
the problem which was coming
we solved that problem
by mixing formulas
I hope you understood everything in this video
if you still have any doubt
then watch this video again
I will meet you in next video
till then keep practicing