hello and welcome to our new video
in this video we are going to learn
how to use end formula
now end formula will remind you
about flash fill
flash fill we have seen
where we can see it
in home tab
do you remember anything
let me show you again
and let me use end formula
to show you how useful it is
so first of all
let me open excel
here i have some data available
some names are written
in side c column
father's name is written
if i tell you that
you have to put mister in front of name
or you have to put doctor in front of name
what will you do
do you remember
flash fill
where you get flash fill
here in home tab
and in editing group
here in class
you get flash fill
in flash fill we used to tell
patterns
i told pattern
that i want mister radheshyam tiwari
after that i used to drag
and all the data used to come to me
rest of the names
used to have prefix
doctor or mister
so here end formula
also works in same way
now how we will use it
we are going to see
all the names are given
now i have to put mister in front of it
so what i will do
i will go here
so to put end formula
you have to put
equals to
so i have put
equals to
after that i have to
put double quote
after that
you have to write
whatever
prefix you want
mister doctor
like i want to put mister
so what i will do
i wrote mister
and after that
i closed this double quote
after doing this
what we have to do
we have to put end
this is end formula
in this end formula
i have to put
in front of which name i have to write
so i have to
write in front of radheshyam tiwari
so what i have done
either directly write b2
or
select this cell
so b2 came automatically
and what i have done
i have entered and here
mister radheshyam tiwari came
we used to do same in flash fill
now if i drag it down
so i know
all the names
what will come in front of this
mister
now in this
there is an interesting thing
like we see in mark sheet
or
we see in wedding cards
like radheshyam tiwari
son of dinesh tiwari
or
like
kiran daughter of
madanlal
like this
i have to
combine these two
father and name
and i have to write
son of or daughter of
so how i can do that
so let's see
so simple is
what i have to write
like mister
i have to put in double quote
after that
i have to put end
so let's see
what i have to do
like
i have to put
in e column
i have to put sign of equals to
after that
i have to write
mister
after that i have to put double quote
after that
i have to put end
and my column name
like my column name is b2
so i have to write
b2
after writing b2
now remember one thing
i am combining two names
so i have to put end
after that
i have to write
son of or daughter of
like i have to write
son of
after that i have to put double quote
ok
here
i have left space
so that i can have some space
after prefix
so that i can have some space
so i have left space
and now i have to put
son of
and again i have to put
end
i have put end
and after that
i have to put
this column name
c2
i have put c2
and now i have to enter
i think it should come
there is a problem with this formula
no trying to type a formula
when the first character
is an equal or minus sign
excel thinks
it's a formula
ok
but we are trying to do this only
equals to
b2
oh sorry
i have put wrong
i have not put end
that's why it's a problem
don't forget this
so here i have put end
both are selected
and here i have put
enter
so this is mr. radhashyam tiwari
there is no space
between tiwari and
space
after this
press space
and now
it will be correct
mr. radhashyam tiwari son of dinesh tiwari
done
now i have to drag it
like this
and when i drag
i have a pattern
now i don't have to do anything
suppose you have
10 row data
or 2000 row data
in that case
it will be very helpful
if i want to do doctor
then it's very simple
what i have to do
i have to edit it
here i have to write doctor
capitalize it
doctor
enter
and this is dr. radhashyam tiwari
now i have to drag it
so all the names
doctor
imran khan
dr. shivam kumar
shivam sharma
dr. deepak varma
and same thing
here
what i have to do
i have to put it in one
and we know
we can drag it
and here
ok
and now
drag it
i hope
it will be clear
how to use end formula
if you have any doubt
then watch this video again
and practice it
it's very important
see you in next video