MID Function दोबारा | Extract First Middle and Last Name without Using Left and Right Function

[@nitinshukla914]

सर जी, यह ट्रिक तो सुपर से डुपर और डुपर से उपर की थी | कौन हो, जो आपकी इन ट्रिक्स का कायल ना हो !!! बेजोड़ = जिसका कोई जोड़ नहीं, लाजवाब = जिसका कोई जवाब नहीं. Fabulous, Magnificent SirG ❤️🙏❤️🙏❤️🙏

[@Innozant]

Thanks Shukla Ji apke itne pyar aur support ke liye .Happy learning 🙏❤️

[@tejpalsain1507]

बड़े कमाल का function हैं ये MID , मिड तो निकाल ही रहा है साथ मे left और right भी । ओर वह सपेन्स शायद स्पेस की पोजिशन को इंडिकेट करता है। सच मे आप हमारा रिवीजन भी कराते रहते हो सर इसके आपका बहुत बहुत धन्यवाद। Thank you very much.

[@Innozant]

Thanks Tejpal ji😀❤️

[@jayantabhattacharyya628]

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

[@Innozant]

Thanks Jayanta.Hope youlike the excel mahaej Mid fornula ❤️🙏

[@sandeepaswal8944]

नमस्ते सर जी सर आज आपकी वजह से ही मुझे एक्सेल मैं बहुत ज्ञान मिला है मै आपका शुक्रिया किस तरह से करू | आपका आशीर्वाद हमेशा बना रहे | मैने power query & excel महाराज playlist revision कर ली है | बहुत कुछ सीखने को मिला | बहुत बहुत धन्यवाद सर जी |

[@Innozant]

Thanks Sadeep Ji..Happy Learning dear

[@rjchoudharyacb]

Thank you sir, इस समस्या का समाधान तो मैने ChatGPT से भी पूछा मगर हल नहीं मिल पाया लेकिन आपके इस वीडियो ने मेरी सारी समय का समाधान कर दिया ✌️😍 Once again Thanks.🙏🎉❤

[@Innozant]

Thanks..Keep Learning..Keep Growing

[@rahulkashyap2704]

Really really easy Thanku SR ji 👍

[@Innozant]

👍❤️🙏

[@sushmapandey7718]

Aapke video dekhker Mai text function bhoat aache se Sikh gayi Hun...

[@Innozant]

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

[@sushmapandey7718]

@@Innozant ok sir😊

[@theblackhawk111]

Suspense hi suspense...👍👍👌👌

[@Innozant]

Still suspense ... Repeat the video again

[@rahulkashyap2704]

It's really amazing sr ji 🤓

[@Innozant]

Thanks Rahul Ji .Happy Learning

[@neerajdevtalla7148]

What a video sir 👌👌👌👌 You're number one teacher ever

[@Innozant]

Thanks Neeraj Ji..Happy Learning dear❤️❤️❤️

[@satishojha6240]

Bahut use hota hai ye function lekin bahut optimse way mai batatey hai sir 🙏🙏🙏. good night sir

[@Innozant]

Thanks Satish Ji..🙏🙏

[@bishtlokesh1297]

Wow 😳 amazing 💖💖🤩🤩 mja aa gya

[@Innozant]

Thanks Lokesh..Best of luck for your interview dear .btana jaisa bhi ho

[@kishorpanara4191]

Ye to super se bhi uperrrrr hai Sir Thank you sir

[@Innozant]

Thanks Kishore ji .Good Night

[@Aghast88]

Your teaching style is great...

[@Innozant]

Thanks Santanu🙏❤️

[@bairaGi_AkB]

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

[@Innozant]

Thanks... hahahaha...apko kaise pata mujhe pasand hai apke yahan ka rasgulla 😊❤️

[@Indian-tech]

Sir Maza aa gaya Ye formula me Thank you so much Sir God bless you

[@Innozant]

Thanks dear

[@merapatients85]

Trust me king of excel love you sir really kings

[@Innozant]

Thanks.. Really means a lot to me

[@faheemkhan7275]

Very nice and informative formula. Thank you

[@Innozant]

❤️👍

[@amitapattanaik1071]

Very good stylist logic, Maza agaya

[@Innozant]

Thanks Salil ji

[@surenderverma8959]

sir, aap bahut badiya bahathe hai thank you sir.

[@gautammishra6395]

Wow,,, awesome trick sir

[@Innozant]

Thanks Gautam.Happy learning ❤️

[@balance1772]

You are my Gurudev🙏🙏🙏🙏🙏🙏🙏

[@bairaGi_AkB]

Thanks, it's a super duper hit formula

[@Innozant]

Thanks

[@Narendar.pathak]

Thanks sir you videos always motivate and help ful

[@Innozant]

Thanks Narender Ji..B happy..nvr stop learning

[@nandinisharma7008]

Excelente sir 😀👌👌

[@Innozant]

Thanks Nandini.. Happy Learning ❤️👍

[@VlogAvi]

thnx sir for the betterment of all the learners

[@rahulkashyap2704]

I aplay that formula in your old video and the Result done👈😁

[@Innozant]

Thanks Rahul .keep it up dear👍❤️

[@shivii88]

Dear sir make a group to add your students hamari bahot si queries hoti h jo aap tak nhi ja pati

[@sajjadhussain3899]

WOW... ONE THE BEST FUNCTION EVER FOR ... TEXT

[@Innozant]

Thanks Sajjad..Happy Learning ❤️🙏

[@nikhilmore6129]

Awesome video sir.. I'm first to comment..🙂

[@Innozant]

Thanks Nikhil Sahab

[@dilipmondal5575]

Great Learning Platform.....Thanks Sir.

[@Innozant]

Thanks Dilip Ji❤️

[@radheprajapati2036]

What a formula..... U r a great

[@Innozant]

Thanks Radhe Prajapati

[@Sarita_Classes]

Sir meri ek hi dil he ..kitne bar jitoge..❤️

[@Innozant]

Hahaha.. Thanks

[@PrabhakarKumar-hb8so]

Thankyu Sir Samjh Mai Aa gaya

[@gulshanmehta6997]

Your are really Amazing Sir!! 😊😊😊 Regards Mehtag

[@Innozant]

Thanks Gulshan.. Happy Learning

[@manojkumarsingh3385]

You are amazing sir 🙏🙏🙏

[@Innozant]

Thanks Manoj ji

[@LovlyAmit]

Greate video. Sir kindly explain kar dijiyega 1*255 ka concept 🙏

[@manojkumarsingh3385]

Very Interesting Sir

[@Innozant]

Thanks

[@johndas8173]

Sir apka formula ko mai और excellent bana diya hu sir

[@Innozant]

Acha jai..kahin aapne mera to kaam nhi kar diya hai😀

[@createyour6681]

Very great sir

[@Innozant]

Thanks

[@maheshswami2064]

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🙏

[@Innozant]

Hahaha.. lovely comment..God bless you .Sukriya dilse ki aapka time kharab nhi vakue add kar pa rhe hain apki life me

[@devmgr500]

Thanks

[@sonukumarskp6933]

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

[@Innozant]

Kaunsa version use kar re h .offuce 7 hai kya..dataset sahi hai? Ya raw data me kuch issue h wo check kren

[@hsgusain2054]

Thanks Sir

[@madhurawasthi1275]

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.

[@Innozant]

Kidny check again..may be you are doing minor mistake in your formula

[@humayoonshah6157]

Sir, I have a table where cell consist of 5 to 9 words, how could I extract 3 words in separate column, please?

[@johndas8173]

Sir us formula me 1* ki jagah me columns ka use karne par dynamic result aa ayega sir

[@hsgusain2054]

Yes

[@Innozant]

Are next video to laane dete aone pehle hi suspense ko.open kar diya g

[@paramjeet975singh3]

Kya sir market mai abi bhi delhi mai excel kisi job mil rahi h kya fresher ki

[@Innozant]

Haan mil rahi h..ab opening aana start ho ra h

[@hiteshchourey9730]

Ye function best hai.

[@ramandeep14590]

Nice sir

[@awanishanurag1763]

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 !!

[@Innozant]

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

[@sridharkrishnappanavanerth3388]

Sir, can you explain the mid formula in the above context and the suspense item in the formula in detail.

[@ARIFSAIFIFARHAN]

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

[@ARIFSAIFIFARHAN]

can you please explain this phenomenon of MS Excel platform

[@deepraazshaw7369]

Sir apke Proquest vidoe Ka intazar hai sir.

[@Innozant]

Yes..Coming sunday again

[@PraveenKumar-el8ty]

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

[@kg1980]

sir kya hum fully functional dashboard website par upload karsake hai kya .. without showing any data if yes plz guide ... thanks

[@Innozant]

Webaite pe kaise update karna vhahte hain..plugins bnanana hai ya db complete

[@kg1980]

@@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

[@dilipmondal5575]

Hi sir, mid formula can help to get proper result for below mention data.

[@Innozant]

Which data ?

[@dilipmondal5575]

@@Innozant Sir if we have name like - (siddhartha shankar kumar baruah)or (Dilip Mondal), can this mid formula work or not.

[@MohammedAli-yk3fd]

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 "

[@Innozant]

Ye we can..Video hai but yaad nhi kaunsa h video

[@uditya.araya.s]

Sir jisme / ya kuch or ho wo kaise niklega uspr v vdo laiye

[@koushikmaity3954]

I would like to know about the multiplication portion like 1*255,2*255 and 3*255. Would you please explain. Thank you..

[@Innozant]

Ok..kisi video example m explain kr dunga..waise kuch students ne comment me reoly kiya hai apko answer mil jayega

[@khemrajrana7322]

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'

[@tarjitmalka3978]

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..

[@Innozant]

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.

[@tarjitmalka3978]

Yes sir i am coming back delhi nd start Next step... VBA or SQL

[@ajitsharma4676]

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?

[@Innozant]

Watch excel maharj series..you may get your answer there

[@ajitsharma4676]

@@Innozant thank you for your reply sir ji....ap jo bhi samjhate ho sir...bilkul samjh me aa jata h...u r great sir...

[@deepraazshaw7369]

Sir last vidoe split name or ye formula same hai sir. Apne usme column liya tha or Yaha aap manually number le Hai.

[@Innozant]

Haan .. Column se formula dynamic aur ho jayega ..jaise last video me liya tya aap can lumn use krke dekhen

[@ravienterprise3682]

Sir ek sell ke andar 3-4 mobile number likha he ushko alag lag karna ho to

[@shaikhyaseen8322]

Use text to colum which already available in excel itself

[@pa2happiness13]

💞👌🏼

[@AshishSingh-hg2gc]

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.

[@tejpalsain1507]

सर excel में स्मार्ट और ऑटोमैट Daybook बनाना सिखाओ । जिसमें kpi डैशबोर्ड भी ऐड हो। plz

[@Innozant]

Thanks Tejpal..Daybook Dashboard bnatabhu free time me

[@RahulRoy-po9ct]

🙏

[@abhisekmohanty23]

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?

[@Innozant]

Kindly watch excel maharaj play list for the same

[@AbhiShek-jr5nd]

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

[@VikasSingh-sv9bp]

Sir concatenate ke formula mein link kaise add karein

[@VlogAvi]

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

[@Innozant]

Great ..Keep it up..👍♥️

[@parthmalik3004]

Agar bich me sirf name and surname ho, toh surname bhi middle name me aa jata hai. iska koi solution hai?

[@durgeshrai8938]

Nyc

[@ayushsinha_1324]

Sir please thoda baate kaam kara kariye 🙏

[@paramjeet975singh3]

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

[@Innozant]

Dubara chrome reinstall krke dekhiye ek baar

[@paramjeet975singh3]

@@Innozant check karta hu...... Sir...

[@muhammadsaqlain5162]

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.

[@Innozant]

Ok..kisi upcoming video me explain kar denge

[@muhammadsaqlain5162]

@@Innozant Ok Sir thank you God bless you.👍👍

[@rajkumarprajapti6821]

Sir agar cell me 4 text hain to kaise karenge

[@johndas8173]

Sir us formula me kal us formula me columns ka formula add karke video post karna sir

[@Innozant]

Acha

[@awanishanurag1763]

Itna hi samajh mei aaya ki cell ka maximum capacity 255 hota hai baaki sab abhi bhi question mark hai!

[@ghumansaab2314]

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]

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?

[@ghumansaab2314]

@@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

[@atulkumargaur8331]

Sir jismein only first aur last name rhega usmein galat aa jayega.... Mid mein hi last name show hoga

[@Innozant]

Uske liye bhi bata rakha kaise karna hai .Learn excel Maharaj series

[@epicclashers2946]

Sir isme muje 1 problem aya jiska sirf first name nd last name hua to uska ye mid mai deta hai last name

[@Innozant]

Means?

[@epicclashers2946]

Matlb sir jese Ram Kumar First mid last Ram Kumar Ab isme last name Kumar ko isne mid mai diya

[@abdullavazhayil4868]

If the name is Anumeet Preet Kaur Singh, how Kaur will be extracted?

[@Innozant]

Kindly watch Text maharaj series for this

[@MAHESHKUMAR-fp7cn]

Sir I have no middle name than how can I exit

[@manojkumarsingh3385]

🙏🙏🙏

[@amitjha6163]

Sir aap se career se regarding baat karni hai apka phon no. Milega?

[@Innozant]

Jha ji..youtube about section me hai Contacy detail ya innozant ke qebsite se le skta hain aur whasapp Karen

[@nehadave9103]

Asariminabensureshbhai ise kaise alag kar sakte

[@Innozant]

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

[@mayursaini27]

Agar sir isme "Anumeet Kaur Singh Delhi" Delhi hota to function mai 4 kar dete

[@Innozant]

Nhi dear ..usse nhi hoga

[@mayursaini27]

@@Innozant फिर kya karengey

[@manojkumarsingh3385]

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

[@Innozant]

Maine btaya to tha aapko.char function use karke condition use kriye..ok koshish krunga kisi aane wale video me add kara sakun

[@manojkumarsingh3385]

@@Innozant Sorry sir Hum nhi Kar pate hai

[@SinghSahab-gg1ow]

Sir

[@Innozant]

Yes Ajeet ji

[@tarjitmalka3978]

⭐⭐⭐⭐⭐

[@Ann_2208]

255 ka logic kiya hai guru ji

[@Innozant]

Koi jarurri nhi 255 char..lein..btaya hai maine dear

[@ajitsharma4676]

Please help.

[@rekha3280]

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??

[@Innozant]

It's not wrong,It will show you the right output Rekha❤️

[@rekha3280]

@@Innozant yep, but it's showing me wrong, don't know why.??

[@usmanyaseen2772]

Mistake in rept function 225? _255_

[@rekha3280]

@@usmanyaseen2772 thanks👏

[@ITTrainerSofcon-Sec6]

very good

[@gauravbhatia7987]

🙏🙏🙏🙏