bhai aap ki jitni b tareef ki jae utni kam hy . me kesi ky liye comments krta nahi margar aap ky kam ko dekh kr me bajbur ho gya ky me aap ki tareef karo . soch me aap tareef ky qabil ho . Allha Pak aap ko lambi zindagi dy Ameen
love the way you explained each things its very easy to understand but i have a complaint to you there is limited videos request you please make more..
agr name asy likha ho aliahmadmustafa or ali ahmad ar mustafa ka darmyan space ni ha space ko ksy enable karain esi tarha ka 1000 names hain kiya koi formula ha excel ma?
If there are two or three parts in list of variou names then pl advise how to extract last part of each name .Your formula holds good for uniform list of names of three parts.
Hi Sir, I have implemented all three formulas but I have a question in RIGHT formula. As u shown that we have to extract the length of the text then we have to minus the space characters right?. But as we can see there are two space characters. So the FIND function will find the space characters and then minus them. But which one space character will minus first and from where (either from right or from left). Please suggest. And thanks for such a wonderful tutorial.
Good Question Raj : End part of the formula =FIND(" ",D4,FIND(" ",D4)+1) ....In this formula second Find ( which gives you "3" and we put +1 also in this formula it means overall output is 4 ) works before first find ( Now this find search a space from 4 position so that next space position is 11 you can count it manually also. I hope you understand now
Hi i have ques. here you use multiple times of find with " " for last and specially for middle word.. its not clear could you please explain how this formula working .. logical point.. how do we know that how many times we will use find and sometimes using +1 and sometimes using -1 well thank you such helpful videos
Calculate how many times your names has spaces . if its 3 then you should to use three times. what +1 Does? When ever you find space then it goes to second alphabet like "Ashish Rawat" .. so first find space then it takes r and -2 is used to remove the last space count
how to find last nmae in dynamic ? like - 1st row- Ram prasad sigh , 2nd row - Hari om 3 rd row - M T Aswani Balachadran = i need ans = 1st row - singh , 2nd row - om , 3rd row - Balachandran
Good Question ... Chandan please use below dynamic formula to solve your query. =IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=1,RIGHT(A1,LEN(A1)-FIND(" ",A1)),IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=2,RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1)+1)),RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1,FIND(" ",A1)+1)+1))))
Hi i have question Let's say i hve 4 outlets i have given them week wise targets. Now i want jis outlet ka target achieve ho jaye wo green ho jaye jiska na ho wo red & targets are different for each outlet. Outlet x target 1500 Achieve 1st week-4000(green) Achieve 2nd week -1300(red) It vll be vertical
WELL EXPLAINED,THOUGH DIFFICULT. COULD NOT UNDERSTAND + 1 OR -1 COMMANDS. CAN YOU EXPLAIN THEM BETTER. MUST ALSO PROVIDE LINK TO DOWNLOAD PRACTICE FILES.
Thanks for your suggestion but in today's world everybody is fluent in excel . So that interviewer asked this split name question by using formula not with text to column.
Hello sir maine aapka video dekha or formula lagaya but y ek cell pe to kaam kar raha tha but maiem jab isko drage kiya to neche wale cell maiem jo name the or is tarha tha a1 cell maiem-mohan kumar sharma a2 cell maine-amit kumr or a3 cell maine Anil likha h ab first b1 maime formula lagaya or jab drage kara to sab kharab ho gaya sir y kis tarah hoga hume yadi ek cell pe hi lagana hoga to mannual likhana aasan h formla to tab kaam karega jab ek baar lagaau or sab pe apen aap lag jaaye please rple me
Mujhe ek name ki table banani hoti hai jo ki Apki date wise hai or mujhe us me problem ye hoti hai ki ,Mujhe us table me jo name continue do bar aaye wo yellow ho jaye or koi name continue three time aaye toh woh auto red ho jaye .Maine bahut try kiya mgr nhi hua pls resolve my problem.
Sir ye Four Find ka role samagh may nahi aaya! Pata hi nahi chal raha hai ye char char find kiyon lagta hai. Please tell me details about four times Find
Mein apko thoda deep me batata hu .. Mid formula me jo pehle find hai vo isliye hai ki kaha se value pick karni hai isse find hoga "M" .uske baad jitne bhi find hai vo sab find kar rahe hai ki pure text me middle wale text me kitne character hai jo ki hai "7" .. to is tarike se ye kaam kar raha hai.
Sir, how to extract names without the initials like Mr.,Mrs., Ms,Dr. etc. The step where I stuck is there may be the names in the data without initials or with initials without a full stop after it like 'Mr' or 'Mr.'. How to do it?
agar names k beech mein space Na hoo toh kaise kaam karega oopar video ka formula. sorry it may be a silly question,. but as I'm an beginner so please bear with me.
Vijay Ji .... Excel me koi bhi formula ya VBA code ek base pe kaam karta hai , hume batana padta hai ki ye condition ka base hai . But aap bataye bina space ke alawa kaise alag karenge or agar alag karenge bhi to uska toh uska koi appropriate answer nhi hoga jo aapke kaam aaeyga.
Deepanshu bisht: SLA is 'Service Level Agreement', which is a contract between the service provider and the internal/external customer that what services will they complete and what will be their performance standards in a given time, whereas KPI is 'Key Performance Indicators' are the roadmap or values as to achieve the SLAs.
Hi, Please tell me formula for Days, i.e I want number of days for leave of 23-08-2017 to 23-08-2017=1 days, because if u calculate in excel it will shows 0 if i shows 23-08-2017 to 24-08-2017 the it calculate 1 days, but in practical it is 2 days leave Thanks
Agar apko is video me samjhna mushkil horaha hai to mein alag alag 3 video banaunga jisme First , Middle and Last name alag alag nikalna sikhaunga or vo har cell me kaam karega.
Thanks for asking this advance question , Your query enhance my skill too. Please use this formula to get Last Name from the Whole Name which having 4 words. "=RIGHT(D5,LEN(D5)-FIND(" ",D5,FIND(" ",D5,FIND(" ",D5)+1)+1))
Waisey mujhy ye video informatic lagi ..you are teaching well ...but your STYLE OF SAYING """"HELLOOOOOOO. ...""""""😥😥is not fit here in such a good video ....it's my view ...if you wish to say this then it's your choice ...just a suggestion only ...n m not against you just suggestion only ..n this is not wrong if I'm correcting you ...its good na
Agreed , somehow Hello in this video is not good but now in few last videos i am saying "Hello" is ok .Thanks for your suggestion and i respect my viewers comment.
Mujhe ek concept samjhe nhi aa rha why we add "+1" in LEN formula. +1 nhi lagye gye toh count jada aa jata h. +1 ka role kya h or ish formula mai lagane se count accurate (cum kyu aata h). Please help me to understand this
Sorry Karan Ji, Maine apka comment kal hi pad lia tha magar socha jab office se free hojau to apko ache se samjhau Is video ke hisab se, Pehle space "r" or "M" ke beech me hai jaise hi formula pehl space find karegato +1 kya karega space ki position 3 hai matlab usme +1 karega to second space jab formula find karega to "M" ke baad wala space find karega, agr aapne +1 nahi lagaya to vo bus pehle space tak ki value remove karke answer aaegya. I hope aapko samajh aya hoga I know thoda difficult hai
sorry to say but problem ho rha h samjhne mai, i am trying to understand but MID and LEN ke formulas crash ho rahe h. I am think why we have not add +1 in LEN formula after 1st space and why we add +1 in MID formula. Request you to share your email address so that i can share my problem by drawing or you can ping me kohlik24@gmail.com please help me in this please
![[Live สด] การออกรางวัลสลากกินแบ่งรัฐบาล งวดวันที่ 16 ธันวาคม 2567](http://i.ytimg.com/vi/dNTiBBthKgQ/mqdefault.jpg)
In last 3-4 years I had use this Formula many time,but today I understood the logic...you are a great teacher.
Your most welcome.
bhai aap ki jitni b tareef ki jae utni kam hy . me kesi ky liye comments krta nahi margar aap ky kam ko dekh kr me bajbur ho gya ky me aap ki tareef karo . soch me aap tareef ky qabil ho . Allha Pak aap ko lambi zindagi dy Ameen
Shukriya Bhai jaan
It is one of the best videos on extracting first, middle and last part of the name. Well explained. Thanks a lot.
Welcome sirji
Very Useful Formula and Your teaching is Awesome Thanking You Sir
Welcome Bro
Maan gaye sir g..... शानदार, जिंदाबाद, जबरदस्त 👌👌👌👌👌
Thanks Deepak
Very Nice Video
Ali Raza Muhammad Jamil ho aur us me se Muhammad select krna ho to kya Formula ho ga ?
Wonderful brother. Thanks for the teaching us with easy way.
Thanks for the comment Irfan
Ali Raza Muhammad Jamil ho aur us me se Muhammad select krna ho to kya Formula ho ga ?
Thanks boss for sharing your knowledge
Welcome Bro
Ali Raza Muhammad Jamil ho aur us me se Muhammad select krna ho to kya Formula ho ga ?
Very Useful Formula Sir Ji...
Thanks ..Mahesh Ji
Waw bahot hi badhiya formule sikhaye sir apne
Welcome Vikas
Great Job
Very very useful formula
Thanku so much
Thanks for the comment Omkar Ji.
love the way you explained each things its very easy to understand but i have a complaint to you there is limited videos request you please make more..
Thanks for appreciating me brother, After some months you can get a lots of video on each topic on my channel.
agr name asy likha ho aliahmadmustafa or ali ahmad ar mustafa ka darmyan space ni ha space ko ksy enable karain esi tarha ka 1000 names hain kiya koi formula ha excel ma?
If there are two or three parts in list of variou names then pl advise how to extract last part of each name .Your formula holds good for uniform list of names of three parts.
very nice Boss
Thanks You Hiren Bro
Hi Sir,
I have implemented all three formulas but I have a question in RIGHT formula. As u shown that we have to extract the length of the text then we have to minus the space characters right?. But as we can see there are two space characters. So the FIND function will find the space characters and then minus them. But which one space character will minus first and from where (either from right or from left). Please suggest.
And thanks for such a wonderful tutorial.
Good Question Raj :
End part of the formula =FIND(" ",D4,FIND(" ",D4)+1) ....In this formula second Find ( which gives you "3" and we put +1 also in this formula it means overall output is 4 ) works before first find ( Now this find search a space from 4 position so that next space position is 11 you can count it manually also.
I hope you understand now
Dont Call me sir brother my name is ashish call me "ash" as a friend
Good video brother
Thanks
Ali Raza Muhammad Jamil ho aur us me se Muhammad select krna ho to kya Formula ho ga ?
Hi i have ques.
here you use multiple times of find with " " for last and specially for middle word.. its not clear could you please explain how this formula working .. logical point.. how do we know that how many times we will use find and sometimes using +1 and sometimes using -1
well thank you such helpful videos
Calculate how many times your names has spaces . if its 3 then you should to use three times. what +1 Does? When ever you find space then it goes to second alphabet like "Ashish Rawat" .. so first find space then it takes r and -2 is used to remove the last space count
Do we have any VBA online knowledge sharing like these formulas
Sorry currently, i have not any video on VBA .
Dear sir, sir mujhe last name, fast name & middle name ye sabhi ek hi rowl me chahiye to plz tel me mujhe btaiye kaise kru plz sir
Brother same formula you can use for your query.
how to find last nmae in dynamic ? like - 1st row- Ram prasad sigh , 2nd row - Hari om 3 rd row - M T Aswani Balachadran = i need ans = 1st row - singh , 2nd row - om , 3rd row - Balachandran
Good Question ... Chandan please use below dynamic formula to solve your query.
=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=1,RIGHT(A1,LEN(A1)-FIND(" ",A1)),IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=2,RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1)+1)),RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1,FIND(" ",A1)+1)+1))))
Hello,
My name Ajay kumar
Can i know how to contact you for other queries or please tell me what hoe calculate the average of 78.60 and 68% in excel
sir plz help me mujhe middle name, fast name & last name ek hi role me chiye alag alag role me nhi to yesa aayga ky plz btao n sir ji
Same row ke liye bhi same formula lagega , bus copy karo to cell me jake pura address copy karna pura cell ek sath nahi
bhoot acha bro
Thanks for the comment AnsarJi.
Hi i have question
Let's say i hve 4 outlets i have given them week wise targets. Now i want jis outlet ka target achieve ho jaye wo green ho jaye jiska na ho wo red & targets are different for each outlet.
Outlet x target 1500
Achieve 1st week-4000(green)
Achieve 2nd week -1300(red)
It vll be vertical
Please share your email Id , So that i can share a excel file with your answer
Thanks its bdevshukla@gmail.com
Please check your inbox, file has been sent to you
Thanks
WELL EXPLAINED,THOUGH DIFFICULT. COULD NOT UNDERSTAND + 1 OR -1 COMMANDS. CAN YOU EXPLAIN THEM BETTER. MUST ALSO PROVIDE LINK TO DOWNLOAD PRACTICE FILES.
Agar space 2 se jada ho fir last name k liye kaun sa formula lagega Jaise - Dr. Mashoor kumar Gulati
One can use the command "Convert Text to columns" to get the result
Thanks for your suggestion but in today's world everybody is fluent in excel . So that interviewer asked this split name question by using formula not with text to column.
Hello sir
maine aapka video dekha or formula lagaya but y ek cell pe to kaam kar raha tha but maiem jab isko drage kiya to neche wale cell maiem jo name the or is tarha tha
a1 cell maiem-mohan kumar sharma
a2 cell maine-amit kumr
or a3 cell maine Anil
likha h ab first b1 maime formula lagaya or jab drage kara to sab kharab ho gaya sir y kis tarah hoga hume yadi ek cell pe hi lagana hoga to mannual likhana aasan h formla to tab kaam karega jab ek baar lagaau or sab pe apen aap lag jaaye please rple me
Mujhe ek name ki table banani hoti hai jo ki Apki date wise hai or mujhe us me problem ye hoti hai ki ,Mujhe us table me jo name continue do bar aaye wo yellow ho jaye or koi name continue three time aaye toh woh auto red ho jaye .Maine bahut try kiya mgr nhi hua pls resolve my problem.
Sir ye Four Find ka role samagh may nahi aaya! Pata hi nahi chal raha hai ye char char find kiyon lagta hai. Please tell me details about four times Find
Wasim Ji, Find utni baar lagega jitni baar space honge apke naam ke bich me.
TeachToEach
Sir ji fir to Dr. Mashoor Gulati ke beech may only two times space hai
to fir four find ka use, how??
Please
Mein apko thoda deep me batata hu ..
Mid formula me jo pehle find hai vo isliye hai ki kaha se value pick karni hai isse find hoga "M" .uske baad jitne bhi find hai vo sab find kar rahe hai ki pure text me middle wale text me kitne character hai jo ki hai "7" .. to is tarike se ye kaam kar raha hai.
Sir, how to extract names without the initials like Mr.,Mrs., Ms,Dr. etc.
The step where I stuck is there may be the names in the data without initials or with initials without a full stop after it like 'Mr' or 'Mr.'.
How to do it?
agar names k beech mein space Na hoo toh kaise kaam karega oopar video ka formula.
sorry it may be a silly question,. but as I'm an beginner so please bear with me.
Vijay Ji .... Excel me koi bhi formula ya VBA code ek base pe kaam karta hai , hume batana padta hai ki ye condition ka base hai . But aap bataye bina space ke alawa kaise alag karenge or agar alag karenge bhi to uska toh uska koi appropriate answer nhi hoga jo aapke kaam aaeyga.
How I can separate 4or5 words please explain sir. Ex. Gunindra Kumar ram das
Sir please 4 word ka bhi video share kre...Is me Aap btye ki kitne bhi word ka Ho sab split Ho jate...
I thought alrrady made video on split 4 name
Good morning sir,
Good Morning Ji and Please don't call me brother you can call my name ASH as like my other friend
can we use "flash fill"
for split name
Nice video. there is a question. How to find "34800" in pay scale "9300-34800 (4800)" ? please help.
Sir please make a video about SLA & KPI i Reject 3 time bcz i dont have knowladge SLA &KPI
Brother this term is generally used in Call Center or BPO , I m not from this industry . But try to make a Wonderful video on your topic.
Deepanshu bisht: SLA is 'Service Level Agreement', which is a contract between the service provider and the internal/external customer that what services will they complete and what will be their performance standards in a given time, whereas KPI is 'Key Performance Indicators' are the roadmap or values as to achieve the SLAs.
Mrs Alexia smith Alexander ... First name will me Mrs and the last name will be Alexandro can you help pls
Hi, Please tell me formula for Days, i.e I want number of days for leave of 23-08-2017 to 23-08-2017=1 days, because if u calculate in excel it will shows 0
if i shows 23-08-2017 to 24-08-2017 the it calculate 1 days, but in practical it is 2 days leave
Thanks
You can use this =(Current Date - Old Date)+1
Ashish bhai aagar name "Vangipurapu Venkata Sai Laxman" hai to kese hoga youtube par ek bhi vedio nahi hai aap bata do
What you want in this means which name you want to split?
I am unable to split 2nd middle name and last name "sai and Laxman".
It shows value for middle name
bro confusion in Left and mid function, Please elaborate it.
Will Make a video where i teach separate all the three methods.
Its Not Dynamic Function Bro If you hv 2 names Like Rahul Thakur and Raj Kumar Rawat How you will find last name with one formula .
Yes Rahul ...This video made by me to teach peoples how we split the names. I will make Dynamic formula .
Thanksgiving
Welcome Raj
ta tou single cell ka liye ha multiple cell ma ya kam ni kary ga kun ka har cell ki LEN change ho ge
Agar apko is video me samjhna mushkil horaha hai to mein alag alag 3 video banaunga jisme First , Middle and Last name alag alag nikalna sikhaunga or vo har cell me kaam karega.
+Teach To Each ok
I need a formula for this can you help
Md Sohayel Islam
Mera fast name kya hai?
Middle name kya hai?
Last name kya hai?
Please reply
Tumhe pata😉
Kayce TH-camr ho tum
pankaj singh balendu yadav, "BALENDU" nikalna hai. formula kya bane ga(=MID(d5,FIND(" ",D5,FIND(" ",D5,FIND(" ",D5)+1,FIND(" ",d5,FIND(" ",d5)+1)-1-FIND(" ",d5).
PLeae check formula is correct.
Bahut hi muskil hi formula
Kafi dimag lagana hoga.
Bilkul Anubhav Ji... Thodi Si Koshish Karo Aajaega
When Will u start videos on vba.
It will take time.
how to find the last name if the name having 4 words so, how to find last name EX: " Comedy night with Kapil " please reply
Thanks for asking this advance question , Your query enhance my skill too. Please use this formula to get Last Name from the Whole Name which having 4 words. "=RIGHT(D5,LEN(D5)-FIND(" ",D5,FIND(" ",D5,FIND(" ",D5)+1)+1))
FIFO invntory kasy bany ga plz
Shoaib ji account me koi format nahi banaya but fir bhi koshish karunga apki kuch help karne ki email id share kardo
TeachToEach shobi2810@gmail.com
SIR ISME +1 OR -1 KY LAGYA GYA MUJHE SAMJHA NAHI AYA
Yaar vo space add n remove ke liye hai
Jaise ye video vaise pura nam banane ki video bi honi chayihe
Blkul honi chaiye , Banaunga jarur Kuldeep ji
How to solve this?
Ayd-abc(2223)-3-225
I need to find 3 from the above text.
Please help
Please make a video 3 space
Ok
Waisey mujhy ye video informatic lagi ..you are teaching well ...but your STYLE OF SAYING """"HELLOOOOOOO. ...""""""😥😥is not fit here in such a good video ....it's my view ...if you wish to say this then it's your choice ...just a suggestion only ...n m not against you just suggestion only ..n this is not wrong if I'm correcting you ...its good na
Agreed , somehow Hello in this video is not good but now in few last videos i am saying "Hello" is ok .Thanks for your suggestion and i respect my viewers comment.
how to split 125 to 25
Mujhe ek concept samjhe nhi aa rha why we add "+1" in LEN formula. +1 nhi lagye gye toh count jada aa jata h. +1 ka role kya h or ish formula mai lagane se count accurate (cum kyu aata h). Please help me to understand this
Sorry Karan Ji, Maine apka comment kal hi pad lia tha magar socha jab office se free hojau to apko ache se samjhau
Is video ke hisab se, Pehle space "r" or "M" ke beech me hai jaise hi formula pehl space find karegato +1 kya karega space ki position 3 hai matlab usme +1 karega to second space jab formula find karega to "M" ke baad wala space find karega, agr aapne +1 nahi lagaya to vo bus pehle space tak ki value remove karke answer aaegya. I hope aapko samajh aya hoga I know thoda difficult hai
sorry to say but problem ho rha h samjhne mai, i am trying to understand but MID and LEN ke formulas crash ho rahe h. I am think why we have not add +1 in LEN formula after 1st space and why we add +1 in MID formula. Request you to share your email address so that i can share my problem by drawing or you can ping me kohlik24@gmail.com please help me in this please
Bhai thoda active hoke bolo
😥heloooooo"..
Kyun style marna😔
What ?
Teach To Each aap hellooooooo ...bolreh hai jara gaur ki jye. ...iska tone ...simple way me bhi bola jaasakta hai ....
how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing using excel
Use right function to get last 2 digit
MODE FUNCTION IS VERY GOOD FOR THIS PROBLEM
Topic acha tha lekin aap sirf slove krte rhe aapne smjhaya nahi
2022
un-necessarily made it so confused.
Bhai middle name nikalna samajh nai aya
Baki dono agya
Try to watch it again.
Sir please explain again
and 1025 to 25 remove 1000 or 100
middle name shammi kapoor ka
I'll better choose "TEXT TO COLUMN"
Yours method is way too lengthy and complicated 👎👎👎
Bakwas video itna lamba formula koi kaise yad rakhega....
thanks sir but ye bahut hi lamba procces hai aapko ye wala video dekhna chahiye th-cam.com/video/dsBNUkvVVfU/w-d-xo.html
Very confusing formula