सर जी, यह ट्रिक तो सुपर से डुपर और डुपर से उपर की थी | कौन हो, जो आपकी इन ट्रिक्स का कायल ना हो !!! बेजोड़ = जिसका कोई जोड़ नहीं, लाजवाब = जिसका कोई जवाब नहीं. Fabulous, Magnificent SirG ❤️🙏❤️🙏❤️🙏
बड़े कमाल का function हैं ये MID , मिड तो निकाल ही रहा है साथ मे left और right भी । ओर वह सपेन्स शायद स्पेस की पोजिशन को इंडिकेट करता है। सच मे आप हमारा रिवीजन भी कराते रहते हो सर इसके आपका बहुत बहुत धन्यवाद। Thank you very much.
Dear Sir What a magic of MID function. You have really explored the A to Z of MID function. I am sure many more excel magic functions are coming for us. Thanks & Regards Jayanta Bhattacharyya
नमस्ते सर जी सर आज आपकी वजह से ही मुझे एक्सेल मैं बहुत ज्ञान मिला है मै आपका शुक्रिया किस तरह से करू | आपका आशीर्वाद हमेशा बना रहे | मैने power query & excel महाराज playlist revision कर ली है | बहुत कुछ सीखने को मिला | बहुत बहुत धन्यवाद सर जी |
Thanks Pandey Ji..M happy for you ...ek eie topic mujhe strong chaiye aapka..Bht jald assessment ke liye invite krenge .. Telegram id -@innozantofficial par msg krke koi bhi query ho to puch lena
Thank you sir, इस समस्या का समाधान तो मैने ChatGPT से भी पूछा मगर हल नहीं मिल पाया लेकिन आपके इस वीडियो ने मेरी सारी समय का समाधान कर दिया ✌️😍 Once again Thanks.🙏🎉❤
Ye sb chamtkar krte rhte ho iske liye jis trh ki feelings aa rhi h tarif krne ke liye Us feeling ke liye mujhe word hi nhi mil rhe ki kese likhu Isliye tarif rhne deta hu😛 Thank u sir ji.. video pe click krne se pahle already pta rhta h ki time khrab nhi hoga🙏
regarding my questiond : If i put " , " instead of space ( " " )then the same function is not working . =TRIM(MID(SUBSTITUTE("," &C76,",",REPT(",",50)),1*50,50)) any suggestion.
Good, if possible do have a video on how to extract folder name and file name. below is an example "C\Users\DESK01\Desktop\Excel Class\Dummy Data.csv "
sir mujhe Jo Mid se dar lgta tha aaj khatam Maine aapke btaye mid method se first second last name. khud se. nikale wo bhi aapke formula se 1*255 ko remove kr k
Hello Sir i have a query at the function nature of Excel so let me clear it please Query - when i make a cell of range as a text( which is visible as a numbers) not possible to apply any mathematical function I understand it. But! when i enter manually number as a text inside the function ("2","3") it is possible to calculate. Why! thanks and regards Arif Saifi
@@Innozant muje difference nahi pata dono me lekin jobhi ho ....data nahi dhikna chahiye aur aap ne jese chart banaye the dashboard me ...aur change bhi horaha tha waise hona chahiye ....bas... daily data update hopaye thanks for your valuable time sir
Sir I have a doubt. If you get some confusing name just as " Ram Kumar Sharma" another name "Priya Agrawal". Both of them we easily find out last name but how can we figure out by single formula last name as Agrawal and Sharma and middle name Kumar in ram Kumar Sharma by single formula . Pls help me
Hello sir, from this formula I am unable to extract failed if name contain only first and last name then getting error. This formula works fine if we have first , middle and Last name but if I have first and middle then what should I do?
sir plz help i want to start excel. or kha se suru kru means class wale data se ya assingmaster wale data se with vedio .. plz guide me ... excellent hona hai excel main..
Sir pls help .. Jab pivot table laga Raha Hu aur kal refresh karta Hu to ye error aata hai .. Offset aur table form dono me Can't open PivotTable source file '[DRI Coal 12.06.2021.xlsx]SA Coal
Sir aap sirf itna apne muh se keh do ki "isko rut jaana hai samajhne ki jarurat nahi hai" , aapki bahut meherbaani hogi aur mujhe bhi tasallii ho jaati sir !!
Hahahaha...Try to understand dear...ek do baar ke practice se aayega. Mid Dobara ek aur video hai usme Maine alag tareeke se bataya hai ek baar use bhi dekhiye
Hello sir, Aapne jo ye function bataya agar hamare paas middle name nahi de rakha first name and last name hai only lekin is function me last name middle name ki jagah par aa raha hai.
If there is multiple names and some with one word name, some with 2 word name, some with 3 word name and some with 4 word name then how this formula works?
NICE SIR BUT agar question ye h ki sheet me kuch name 4 word k is tarah ( MR. Ajay Kumar Sharma" FUll name h to isme ye pucha h ki Prefix, Mr, Ajay first name , Kumar mid name or sharma last name h b or kuch 3 word k h to kis tarah nikelaga answer sir'
sir formula to thik hai but agar kabhi sentence kahin 2 word ka kahin 4 ka ho to ye useful ni hai agar ko perfect formula ho jo right ki satik value fatch kar de to please batayen
Sir mera query data refresh nahi hota error aata hai ( External Data Connection Have been Disabled ) iska kya solution hai ? Sir please iska solution bta do ?
@@Innozant Sir Jab File closed karke reopen karta hu to refresh nai hota or connection chek karne par error Show hota hai ( External Data Connection Have been Disabled) ye error a raha hai
Sir Plz apko yaha batana hoga k (1*255) ko multiply Q kiya ap nay? iska concept bata den Q k mere pas chrom os hai is man evaluate ker k nahi dekh sakta meri majburi hai plz sir, Aur dusra ye k ap nay pehlay " "k sath & Q lagaya? kya pehlay & laga ker " " k space den to koye problem to nahi hogi? plz tell me.
Isme se kya extract karna hai ? Neha aap channel me playlist hai excel maharaj usme Sum Maharaj series ke video dekhiye..apko answer mil jayega apne query ka
Sir Aap Ka bahut Abhari Rahunga Humari problem ko solve Kar dijiye 1=B 2=I 3=M 4=J 5=K 6=S 7=U 8=P 9=X 0=Y SIR Agar Hume price 23465 Likhe to IMJSK ME Convert ho jay Plz Help Me Sir
I applied this formula" TRIM(MID(SUBSTITUTE(" "&A2," ",REPT(" ",225)),1*255,255)) " and I got Middle Name When I put this One " TRIM(MID(SUBSTITUTE(" "&A2," ",REPT(" ",225)),2*255,255)) " My ans. was last name. Could any one tell ,where I did mistake??
सर जी, यह ट्रिक तो सुपर से डुपर और डुपर से उपर की थी |
कौन हो, जो आपकी इन ट्रिक्स का कायल ना हो !!!
बेजोड़ = जिसका कोई जोड़ नहीं,
लाजवाब = जिसका कोई जवाब नहीं. Fabulous, Magnificent SirG ❤️🙏❤️🙏❤️🙏
Thanks Shukla Ji apke itne pyar aur support ke liye .Happy learning 🙏❤️
बड़े कमाल का function हैं ये MID , मिड तो निकाल ही रहा है साथ मे left और right भी ।
ओर वह सपेन्स शायद स्पेस की पोजिशन को इंडिकेट करता है।
सच मे आप हमारा रिवीजन भी कराते रहते हो सर इसके आपका बहुत बहुत धन्यवाद।
Thank you very much.
Thanks Tejpal ji😀❤️
Dear Sir
What a magic of MID function. You have really explored the A to Z of MID function. I am sure many more excel magic functions are coming for us.
Thanks & Regards
Jayanta Bhattacharyya
Thanks Jayanta.Hope youlike the excel mahaej Mid fornula ❤️🙏
sir, aap bahut badiya bahathe hai thank you sir.
नमस्ते सर जी सर आज आपकी वजह से ही मुझे एक्सेल मैं बहुत ज्ञान मिला है मै आपका शुक्रिया किस तरह से करू | आपका आशीर्वाद हमेशा बना रहे | मैने power query & excel महाराज playlist revision कर ली है | बहुत कुछ सीखने को मिला | बहुत बहुत धन्यवाद सर जी |
Thanks Sadeep Ji..Happy Learning dear
Trust me king of excel love you sir really kings
Thanks.. Really means a lot to me
Thankyu Sir Samjh Mai Aa gaya
Ye to super se bhi uperrrrr hai Sir Thank you sir
Thanks Kishore ji .Good Night
Aapke video dekhker Mai text function bhoat aache se Sikh gayi Hun...
Thanks Pandey Ji..M happy for you ...ek eie topic mujhe strong chaiye aapka..Bht jald assessment ke liye invite krenge .. Telegram id -@innozantofficial par msg krke koi bhi query ho to puch lena
@@Innozant ok sir😊
Thank you sir, इस समस्या का समाधान तो मैने ChatGPT से भी पूछा मगर हल नहीं मिल पाया लेकिन आपके इस वीडियो ने मेरी सारी समय का समाधान कर दिया ✌️😍 Once again Thanks.🙏🎉❤
Thanks..Keep Learning..Keep Growing
Suspense hi suspense...👍👍👌👌
Still suspense ... Repeat the video again
Really really easy
Thanku SR ji 👍
👍❤️🙏
thnx sir for the betterment of all the learners
Wow,,, awesome trick sir
Thanks Gautam.Happy learning ❤️
WOW... ONE THE BEST FUNCTION EVER FOR ... TEXT
Thanks Sajjad..Happy Learning ❤️🙏
Your teaching style is great...
Thanks Santanu🙏❤️
Dear sir make a group to add your students hamari bahot si queries hoti h jo aap tak nhi ja pati
Very nice and informative formula. Thank you
❤️👍
You are my Gurudev🙏🙏🙏🙏🙏🙏🙏
Thanks, it's a super duper hit formula
Thanks
Sir
Maza aa gaya
Ye formula me
Thank you so much Sir
God bless you
Thanks dear
Thanks
Very good stylist logic, Maza agaya
Thanks Salil ji
It's really amazing sr ji
🤓
Thanks Rahul Ji .Happy Learning
What a video sir 👌👌👌👌
You're number one teacher ever
Thanks Neeraj Ji..Happy Learning dear❤️❤️❤️
Great Learning Platform.....Thanks Sir.
Thanks Dilip Ji❤️
Excelente sir 😀👌👌
Thanks Nandini.. Happy Learning ❤️👍
Bahut use hota hai ye function lekin bahut optimse way mai batatey hai sir 🙏🙏🙏. good night sir
Thanks Satish Ji..🙏🙏
Thanks sir you videos always motivate and help ful
Thanks Narender Ji..B happy..nvr stop learning
Wow 😳 amazing 💖💖🤩🤩 mja aa gya
Thanks Lokesh..Best of luck for your interview dear .btana jaisa bhi ho
Thank you very much for teaching me such s magical mid function, and for this I will pay you back as a Gurudakshina, a kalkatian Rosogolla
Thanks... hahahaha...apko kaise pata mujhe pasand hai apke yahan ka rasgulla 😊❤️
What a formula.....
U r a great
Thanks Radhe Prajapati
Ye function best hai.
Greate video. Sir kindly explain kar dijiyega 1*255 ka concept 🙏
Thanks Sir
Sir meri ek hi dil he ..kitne bar jitoge..❤️
Hahaha.. Thanks
I aplay that formula in your old video and the Result done👈😁
Thanks Rahul .keep it up dear👍❤️
Sir apka formula ko mai और excellent bana diya hu sir
Acha jai..kahin aapne mera to kaam nhi kar diya hai😀
Very Interesting Sir
Thanks
Very great sir
Thanks
You are amazing sir 🙏🙏🙏
Thanks Manoj ji
🙏
Nice sir
Your are really Amazing Sir!!
😊😊😊
Regards
Mehtag
Thanks Gulshan.. Happy Learning
Awesome video sir.. I'm first to comment..🙂
Thanks Nikhil Sahab
Sir, can you explain the mid formula in the above context and the suspense item in the formula in detail.
Nyc
Sir us formula me 1* ki jagah me columns ka use karne par dynamic result aa ayega sir
Yes
Are next video to laane dete aone pehle hi suspense ko.open kar diya g
💞👌🏼
Sir apke Proquest vidoe Ka intazar hai sir.
Yes..Coming sunday again
Kya sir market mai abi bhi delhi mai excel kisi job mil rahi h kya fresher ki
Haan mil rahi h..ab opening aana start ho ra h
Hi sir,
mid formula can help to get proper result for below mention data.
Which data ?
@@Innozant Sir if we have name like - (siddhartha shankar kumar baruah)or (Dilip Mondal), can this mid formula work or not.
Ye sb chamtkar krte rhte ho iske liye jis trh ki feelings aa rhi h tarif krne ke liye
Us feeling ke liye mujhe word hi nhi mil rhe ki kese likhu
Isliye tarif rhne deta hu😛
Thank u sir ji.. video pe click krne se pahle already pta rhta h ki time khrab nhi hoga🙏
Hahaha.. lovely comment..God bless you .Sukriya dilse ki aapka time kharab nhi vakue add kar pa rhe hain apki life me
Sir last vidoe split name or ye formula same hai sir. Apne usme column liya tha or Yaha aap manually number le Hai.
I would like to know about the multiplication portion like 1*255,2*255 and 3*255. Would you please explain. Thank you..
Ok..kisi video example m explain kr dunga..waise kuch students ne comment me reoly kiya hai apko answer mil jayega
Sir jisme / ya kuch or ho wo kaise niklega uspr v vdo laiye
regarding my questiond : If i put " , " instead of space ( " " )then the same function is not working .
=TRIM(MID(SUBSTITUTE("," &C76,",",REPT(",",50)),1*50,50)) any suggestion.
Kidny check again..may be you are doing minor mistake in your formula
Sir, I have a table where cell consist of 5 to 9 words, how could I extract 3 words in separate column, please?
Good, if possible do have a video on how to extract folder name and file name.
below is an example "C\Users\DESK01\Desktop\Excel Class\Dummy Data.csv
"
Ye we can..Video hai but yaad nhi kaunsa h video
🙏🙏🙏
sir mujhe Jo Mid se dar lgta tha aaj khatam
Maine aapke btaye mid method se
first second last name. khud se. nikale wo bhi
aapke formula se 1*255 ko remove kr k
Great ..Keep it up..👍♥️
Sir concatenate ke formula mein link kaise add karein
Hello Sir
i have a query at the function nature of Excel so let me clear it please
Query - when i make a cell of range as a text( which is visible as a numbers) not possible to apply any mathematical function
I understand it.
But! when i enter manually number as a text inside the function ("2","3") it is possible to calculate. Why!
thanks and regards
Arif Saifi
can you please explain this phenomenon of MS Excel platform
sir kya hum fully functional dashboard website par upload karsake hai kya .. without showing any data
if yes plz guide ... thanks
Webaite pe kaise update karna vhahte hain..plugins bnanana hai ya db complete
@@Innozant muje difference nahi pata dono me
lekin jobhi ho ....data nahi dhikna chahiye aur aap ne jese chart banaye the dashboard me ...aur change bhi horaha tha waise hona chahiye ....bas...
daily data update hopaye
thanks for your valuable time sir
Sir I have a doubt. If you get some confusing name just as " Ram Kumar Sharma" another name "Priya Agrawal". Both of them we easily find out last name but how can we figure out by single formula last name as Agrawal and Sharma and middle name Kumar in ram Kumar Sharma by single formula . Pls help me
Hello sir, from this formula I am unable to extract failed if name contain only first and last name then getting error. This formula works fine if we have first , middle and Last name but if I have first and middle then what should I do?
Itna hi samajh mei aaya ki cell ka maximum capacity 255 hota hai baaki sab abhi bhi question mark hai!
sir plz help i want to start excel. or kha se suru kru means class wale data se ya assingmaster wale data se with vedio .. plz guide me ... excellent hona hai excel main..
Kisi se bhi start kar sakte hain..video wise karna hai to wo bhi better..but start your Learning now..aur aage badho lolife me.
Yes sir i am coming back delhi nd start Next step... VBA or SQL
Sir pls help ..
Jab pivot table laga Raha Hu aur kal refresh karta Hu to ye error aata hai ..
Offset aur table form dono me
Can't open PivotTable source file '[DRI Coal 12.06.2021.xlsx]SA Coal
Kaunsa version use kar re h .offuce 7 hai kya..dataset sahi hai? Ya raw data me kuch issue h wo check kren
सर excel में स्मार्ट और ऑटोमैट Daybook बनाना सिखाओ । जिसमें kpi डैशबोर्ड भी ऐड हो। plz
Thanks Tejpal..Daybook Dashboard bnatabhu free time me
Sir ek sell ke andar 3-4 mobile number likha he ushko alag lag karna ho to
Sir aap sirf itna apne muh se keh do ki "isko rut jaana hai samajhne ki jarurat nahi hai" , aapki bahut meherbaani hogi aur mujhe bhi tasallii ho jaati sir !!
Hahahaha...Try to understand dear...ek do baar ke practice se aayega.
Mid Dobara ek aur video hai usme Maine alag tareeke se bataya hai ek baar use bhi dekhiye
Hello sir, Aapne jo ye function bataya agar hamare paas middle name nahi de rakha first name and last name hai only lekin is function me last name middle name ki jagah par aa raha hai.
Sir please thoda baate kaam kara kariye 🙏
If there is multiple names and some with one word name, some with 2 word name, some with 3 word name and some with 4 word name then how this formula works?
Kindly watch excel maharaj play list for the same
Sir agar cell me 4 text hain to kaise karenge
NICE SIR BUT agar question ye h ki sheet me kuch name 4 word k is tarah ( MR. Ajay Kumar Sharma" FUll name h to isme ye pucha h ki Prefix, Mr, Ajay first name , Kumar mid name or sharma last name h b or kuch 3 word k h to kis tarah nikelaga answer sir'
Sir
Yes Ajeet ji
Sir us formula me kal us formula me columns ka formula add karke video post karna sir
Acha
sir formula to thik hai but agar kabhi sentence kahin 2 word ka kahin 4 ka ho to ye useful ni hai agar ko perfect formula ho jo right ki satik value fatch kar de to please batayen
Agar bich me sirf name and surname ho, toh surname bhi middle name me aa jata hai. iska koi solution hai?
⭐⭐⭐⭐⭐
Sir mera query data refresh nahi hota error aata hai ( External Data Connection Have been Disabled ) iska kya solution hai ? Sir please iska solution bta do ?
Iption me jaake synonym table jitne bhi hain sab par check kr dena..ho jayega sahi..kis tike aata h error jab refresh krte ho?
@@Innozant Sir Jab File closed karke reopen karta hu to refresh nai hota or connection chek karne par error Show hota hai ( External Data Connection Have been Disabled) ye error a raha hai
If the name is Anumeet Preet Kaur Singh, how Kaur will be extracted?
Kindly watch Text maharaj series for this
Sir jismein only first aur last name rhega usmein galat aa jayega.... Mid mein hi last name show hoga
Uske liye bhi bata rakha kaise karna hai .Learn excel Maharaj series
Agar sir isme "Anumeet Kaur Singh Delhi" Delhi hota to function mai 4 kar dete
Nhi dear ..usse nhi hoga
@@Innozant फिर kya karengey
Sir Plz apko yaha batana hoga k (1*255) ko multiply Q kiya ap nay? iska concept bata den Q k mere pas chrom os hai is man evaluate ker k nahi dekh sakta meri majburi hai plz sir, Aur dusra ye k ap nay pehlay " "k sath & Q lagaya? kya pehlay & laga ker " " k space den to koye problem to nahi hogi? plz tell me.
Ok..kisi upcoming video me explain kar denge
@@Innozant Ok Sir thank you God bless you.👍👍
Asariminabensureshbhai ise kaise alag kar sakte
Isme se kya extract karna hai ?
Neha aap channel me playlist hai excel maharaj usme Sum Maharaj series ke video dekhiye..apko answer mil jayega apne query ka
Sir I have no middle name than how can I exit
255 ka logic kiya hai guru ji
Koi jarurri nhi 255 char..lein..btaya hai maine dear
Sir isme muje 1 problem aya jiska sirf first name nd last name hua to uska ye mid mai deta hai last name
Means?
Matlb sir jese
Ram Kumar
First mid last
Ram Kumar
Ab isme last name Kumar ko isne mid mai diya
Sir mere laptop mai google open hi ni ho raha hai.. Jaise double click karta hu.... Round round ghumta hai fir ruk jata hai.. Pls help me
Dubara chrome reinstall krke dekhiye ek baar
@@Innozant check karta hu...... Sir...
Sir aap se career se regarding baat karni hai apka phon no. Milega?
Jha ji..youtube about section me hai Contacy detail ya innozant ke qebsite se le skta hain aur whasapp Karen
Please help.
Sir Aap Ka bahut Abhari Rahunga
Humari problem ko solve Kar dijiye
1=B
2=I
3=M
4=J
5=K
6=S
7=U
8=P
9=X
0=Y
SIR Agar Hume price 23465 Likhe to
IMJSK ME Convert ho jay
Plz Help Me Sir
Maine btaya to tha aapko.char function use karke condition use kriye..ok koshish krunga kisi aane wale video me add kara sakun
@@Innozant Sorry sir
Hum nhi Kar pate hai
I applied this formula" TRIM(MID(SUBSTITUTE(" "&A2," ",REPT(" ",225)),1*255,255)) " and I got Middle Name
When I put this One " TRIM(MID(SUBSTITUTE(" "&A2," ",REPT(" ",225)),2*255,255)) " My ans. was last name.
Could any one tell ,where I did mistake??
It's not wrong,It will show you the right output Rekha❤️
@@Innozant yep, but it's showing me wrong, don't know why.??
Mistake in rept function 225? _255_
@@usmanyaseen2772 thanks👏
very good
🙏🙏🙏🙏