Excel MID Function | How to use MID Function in Excel | Example with Explanation

[@jugnupower2615]

Really you are very innocent. I tried hard to understand mid function from others but they are only following 'ratta mar' formula, which I could understand. But KZbin recommended me your lecture, and I am honestly saying that my doubt has been cleared from you.😊

[@Innozant]

I am very glad and very astound to help you your love keeps me motivated to fetch up this amazing quality content for y'all keep Supporrting and I will always be your teacher and prepare you for the hardships.

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@shahzadsiddiqui5117]

this is the best way MID function can be explained sir...respect

[@Innozant]

Thanks dear

[@partnerbookkeeper]

this is what I am looking for. Although I don't understand the language, I think you have explained it pretty well.

[@Innozant]

Thanks. Explained in Hindi language

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@sandeepbhargava2714]

Never found Mid function so easy Your teaching style is really great. Now the concept is clear and I can say Mid is lengthy, not tough

[@Innozant]

Thanks Sandeep Ji..Keep Learning

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@shaalam2096]

Sir your teaching method is Excilent. Your explain process is very simple . I am fan of teaching. I watching vdo everyday in sequence.

[@Innozant]

Thanks Md Alam Sahab itne pyare comment Karne ke liye..Hope ye videos Aapke life me value add Kar pa rahe Hain..❤️❤️👍👍🙏🙏

[@medumedu557]

Very well explained. Hardly I find any youtuber explaining in depth like you.

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@sandeepaswal8944]

सर बहुत ही अच्छे से समझाया आपने | मुझे ये अच्छे से इसलिये समझ आया क्युकी मैने आपके वीडियो की tutorial शुरू से देखे है|और रात दिन खूब प्रैक्टिस करी है| | मुझे MID Function मै अब कोई दिकत नहीं होरी है | आप हम सबको बहुत ही अच्छा ज्ञान प्रदान करै हो | भगवान से दुआ करता हूँ आपको खूब तरिकी दे |

[@Innozant]

धन्यवाद संदीप ,आशा करता हु आपको समज आया होगा कांसेप्ट

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@user-jc6te1vm8v]

no one desribed mid function as clearly as u sir.... well taught

[@Innozant]

Thanks For such a valuable and lovely comment.

[@raselzamadder276]

I'm from Bangladesh. You are my BOSS for Excel.

[@Innozant]

Thanks Rasel..Happy learning dear..God bless you.. Recommend you to start your learning journey from playlist Basic Excel onwards

[@ronit496]

Sir aaj hi pehla video dekha aapka aur sachme best teacher hai aap. May god bless you Sir ❤

[@Innozant]

Thanks Ronit...We welcome 🙏 you to experience the taste of success. Recommend you to start your learning journey from Playlist basic excel

[@souravsingh4472]

Sir you helped me alot through your helpful videos, may god gives you all the things you deserved ❤

[@artisticdraw]

If every school and college had a teacher like you, no any student would ever be weak. Great sir 👏

[@Innozant]

Really means a lot to me.Keep leaening.Keep exploring

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@iamsainipawan]

Sir Aapne toh mid function Ka operations Kar Diya aur acche SE samja bhi Diya kamaal hai sir aap sir mein fan ho Gaya Aapke teaching style ka 🙏🙏

[@Innozant]

Hahaha..Thanks Pawan Ji

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@RohitKumar-cc7zi]

Dear you are always right, need thumps up for you 👍

[@Innozant]

Thanks Rohit Ji..Happy learning dear

[@islamcknowledge7737]

Thank you sir bahut badhiya se samajh me aa gaya ❤❤❤

[@abhishekbhalerao9295]

Thank you so much...............i watched 10-20 videos for this MID function but you easily guided in applying...Shout out to you Sir, please keep us the good work.

[@Innozant]

Really means a lot to me

[@FaizanKhan-ts2lm]

The way of your teaching and explaining is fantastic. I am really impressed. I want to thank you for the amazing stuff that you provided. It helps a lot to learn excel in a manner way from zero to advance. I watched and practised till mid-function. I don't have any doubt regarding any function that I have learned.

[@Innozant]

Thanks Faizan . Really means a lot to me dear

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@muhammadsaqlain5162]

Bohot zaberdast trick bataya sir ap nay not difficult 💯 but ap nay bohot zaberdast tareekay se samjhaya hai you are very technical person in excel 👍💯.

[@Innozant]

Thanks dear

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@rajeevranjan2478]

Thank you sir. Its really helpful.

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@pushkarsinghbishtuk437]

You are lagend of Excel formulas

[@Innozant]

Thanks dear...God bless you

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@susantadas2209]

Your first example make me easy more to understand mid function. Thank you.

[@Innozant]

Thanks dear👍♥️

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@wrongturnlima007]

Mid ka formula aapse achha koi nhi samjha sakta hai 🙏🙏🔥🔥👍👌👌

[@Innozant]

Love you dear..apke ye comment sachme bht eham hain Dhiraj

[@keshavhotwheelscollection]

Sir it requires a lot of patience to teach such formulas very good job you are doing

[@Innozant]

Really means a lot to me

[@shaikjaveed3934]

Bahot hi behtareen way hai sir app ka Easy to understand and your example also too good. Thank you very much sir 😊

[@Innozant]

Thanks Shaik Javeed Ji..Happy learning ❤️

[@darylmendonca874]

You just explain so nicely.. appreciate your efforts

[@Innozant]

Thanks a lot 😊

[@aaqibpundeer9156]

awesome...itne mahnat kon karta samjhane k liye..really

[@Innozant]

Thanks Aaqib ,Ye Mehnat sirf aaplogon liye dear .. Wishing you wonderful career ahead.Acha kariye life me👍❤️

[@amazingindiabyshiva8357]

Vinod Kumar Rathore Jaipur Sir isme se mujhe Rathore ko Nikalna hai but nhi nikal paa rha hai to kya kru pls suggest?

[@amazingindiabyshiva8357]

Sir Iska reply kr dena pls

[@factad6582]

finally i can understand MId mene is video ko bahut baat play back kr ke dekha hai thankyou sir jiii

[@Innozant]

👍😊❤️

[@vishalpal3165]

Last mein+1 kisliye kiya

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@pushkarsinghbishtuk437]

Sir ye formula bilkul chipak gya dimag me maja aa rha hai kaam karne me ab Thank you so much sir 🙏🙏🙏🙏

[@Innozant]

Great dear❤️👍

[@pratyushnigam8956]

Sir you you are the best teacher of Excel on KZbin........ concepts which are difficult to understand are now crystal clear....... your teaching style reflects the purity of your character.....🙌🙌🙌🙌🙌🙌

[@Innozant]

Thanks Pratyush ji..God bless You dear.. Happy Learning

[@avdesharyan3827]

Amazing Explaination !! You are ALT+TUF !! Rockstart of Excel

[@Innozant]

Hahahaha.. Thanks Abhishek ji.Happy Learning ♥️

[@seedhibaat7741]

Very good teacher. Respect from Pakistan Sir.

[@Innozant]

Thanks Dear...Happy Learning..

[@balamira297]

So interesting to understand sir but good teaching style!

[@Innozant]

Thanks Mira,Kindly do your practice on regular basis..Mis Assignment Master Exercise link are there in video description ❤️❤️

[@waheedhabib5078]

Sir g it was very difficult topic... But u make us understand really good

[@Innozant]

Thanks Waheed ji

[@sekharispassion]

Was searching for this function explanation. Now I can understand the concept of spaces in text. Thank you.

[@Innozant]

Thanks dear👍❤️❤️

[@sarfrazahmad2223]

Really outstanding sir 👍

[@HarshKumar-qy6fh]

Sir , loved your all lesson , good job

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@ashishsharmasmiles]

Very nice explanation ✌

[@jyothinayak8097]

Your viedo helped me to solve thr difficult query of excel. Thank you very much for this viedo & help

[@Innozant]

Thanks Jyoti👍❤️

[@kartikeyasharma6476]

Sir aap to zabardast ho🤩🤩🤩🤩👌👌👌🙏🙏🙏🙏🙏🙏

[@jaishrisaxena1083]

This function is really very confusing, i had tried to learn From so many other video brfore, but no one clarified this way ,as u did. yes it is difficult, but u made this easy for all of us. Thanks a loooooot!

[@unboxingreviewvlog7009]

Me too having difficulty in understanding this formula.

[@Innozant]

Thanks

[@pushkarsinghbishtuk437]

Aapse excel sikhar bahut acche se samjh me aata hai

[@Innozant]

Thanks Pushkar

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@mainurrahman5741]

Thanks you sir. I am from Bangladesh, I watching your every video.

[@Innozant]

Thanks dear

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@paresh1233]

Thanks sir, aap ki kaam ke ho mere liye. Thanks a lot even u have good teaching skills

[@Innozant]

Thanks Dear,Watch All Video step by Step from Basic Excel Playlist onwards..

[@kirtimandhyan2263]

Finally found one useful video

[@Mech545]

Thank you sir bahut acha laga aapka video dekh kar bahut badhiya

[@Innozant]

Thanks Devendra ji

[@rajkumar10gupta220]

You are the best sir

[@heeralalkumawat2132]

Excellent 👌

[@ashishjha5123]

Wah sir gjb ❣️

[@surajsawant.2220]

Hello Sir, Pranam🙏🙏i in this not better to use "text to column" features instead of using mid function when we found any kind of delimeter in-between?

[@Innozant]

Offcourse TTC is good option when you are looking for static solution (i.e. extract only once) but when you have dynamic content ?Formula is the only solution 😊

[@surajsawant.2220]

@@Innozant Yes sir, for dynamic data, "formula" is the only option we have.🙏🙏

[@rovar7104]

Sir aapne 9:16 pe text selection kiya or vo Direct 9 number me convert huva vo kaise kiya can you please tell me

[@Innozant]

Evaluate kiya hai by pressing F9

[@rovar7104]

@@Innozant thanks 😁❤️🙏❤️

[@horrorlovestories]

Sir jab ek space aage chale jaaye to minus find karna hota hai last example mid function mein?

[@Innozant]

Haan dear

[@aptrends3257]

Thank you Sir kafi Aache se teach kiya apne

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@Altaf_Alam]

Good morning sir ❤️🔥 Concept is power....and you teach us 🔥🔥🔥

[@Innozant]

Thanks Altaf..Keep Learning

[@manishanegi9132]

In this example and in all the previous ones, we have taken names that had three parts and hence we could find out the last and mid names. What should be done if there are more than three parts?

[@dpak_sharma]

Thanks sir mera bhi Mid function clear ho gya ab

[@Innozant]

♥️♥️👍👍

[@TheLe0-l3h]

Your videos are amazing. How can we can do it if there was " slash " rather than " colon " . What I mean is that how I extract middle name with same delimiter.

[@manisaighantasala7664]

Superb broo!!!!

[@vani_3606]

Really helpful! Thanks sir for this lecture.

[@Innozant]

Thanks Vani.Happy Learning dear..Recommend you to start your learning journey from Playlist Basic Excel onwards

[@razaseemab8572]

Sir ,Excellent way of teaching 👍

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@pallavibarman5618]

Thank Sir,very nicely understood.The video is very useful.

[@Innozant]

Thanks

[@manishshukla4696]

Sir, I got a question in an interview where I have to extract "@" from a given email id

[@jobtsnrao3496]

SIMPLY SUPERB BROTHER

[@Innozant]

Thanks dear...Happy learning

[@anjaligulatiamb_123]

Sir, mera thoda clear kr dijiye.. House number 534,sector 10,amba city. Isme mughe 534 extract krna hai . House or number or 534 mein space hai . . MID(A1,find(" ",A1,find(" ",A1)+1),find(",",A1)-find(" ",A1,find(" ",A1)-1)) Ab mugje isme se 534 nhi nikal pa rahi sir. Khan bhool ho rahi hai

[@nirbhayshankar7238]

Ye to textafter and textbefore se bhi nikal sakte hai easily, sir multiple criteria ke saath wala kuch complex wala sikhaiya

[@pramodkumar-ke8gd]

Logic Aaj clear huaa hai, ab tak to ratta tha

[@pramodkumar-ke8gd]

It is very helpful to me, tnx a lot

[@akashbarua3982]

You are so great teach,sir

[@antiquehydra7549]

Wowww sir fantastic.... your expansion method is awesome 🔥🔥 great sir.. thank you sooo much for this, my hand just went quickly on subscribe button 😃

[@Innozant]

Thanks dear❤️❤️

[@shrikantbadge3978]

बार बार देखो, हजार बार देखो, ये देखणे की चीज हैं हमारा INNOZANT...

[@Innozant]

Hahahaha.Lovely

[@karankapoor200]

you are great sir apki jitni tareef karu utna kam h sir sir apna aja Ki sheet m mara name bhi tha sir apa KZbin cheenel bhohott tarki kara sir or eak din apka KZbin cheenel puri duniya ma fail jay sir ma bhagwan say ya hi pry karuga sir🙏🙏 OK sir happy Raksha bandhan 👍🏻

[@Innozant]

Thanks Karan,apka name yaad tha to aa gye aap example me.❤️,Hope apko mid ka concept samjh me aaya hoga.

[@karankapoor200]

@@Innozant clear to hi gya but laptop ma karuga

[@engg.sudarshanverma6599]

Now MID function is not looking difficult. Thanks for making us understand very minutely

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@soniatyagi5541]

Thanks sir .. ur concepts are so easy to understand

[@Innozant]

Thanks Sonia...We welcome you to experience the taste of Success with Innozant -Seed of Success. Recommend you to start your learning journey from Playlist Basic Excel Onwards ❤️🙏

[@dhakafady774]

sir i am from bangladesh , sir really thanks a lot sir

[@rudrapandat5541]

Guruji you're great !

[@Innozant]

Thanks dear❤️

[@editingzone2.029]

Ager sir find ke badla search lagaye tho dono me keya anther hai

[@ashishjha5123]

Sir yha hum / ke jagah space bhi find kr sakte h kya

[@Innozant]

Bilkul Jha ji

[@vikasgawaria5330]

Nice video sir Sir ek video data cleaning pe bana dijiye excel ka basic to advanced

[@zilehusnain6900]

agr 2sri space per rehty howay 3sri space ko find krna hy tu keya krain gy?

[@sachidanandkumar9861]

Beautiful, you Lit 🔥🔥 sir.

[@nitinbajaj9436]

Sir, which key you click to show/evaluate the numbers (for example you showed to us 9,13) between formula, how it comes like 9 and then you click something it shows back as formula, suddenly 9 become disappear

[@Innozant]

Select part of formula and press F9 to evaluate Then go back to formula press ctrl z

[@nitinbajaj9436]

@@Innozant Thank you so much Sir for your prompt reply

[@RA-rh5lb]

Sir ji aise debug wala video aur banayee na please.. ye wala video ko muje aur das baar tho dekhna padega concept samj ne ke liye.. thanks in advance.

[@Innozant]

👍

[@abdullavazhayil4868]

How it will be if there is more words and separators like dash. For example there is drawing number with 6 words and 5 dashes...how find fourth dash or fourth word...I am working as document controller...I tried your method to find fourth dash or word but failed ..

[@rahulcmohan2866]

Can this be applied to cells in other formats? For example: date format separated by hyphens?

[@mixvideos48]

Its link help you kzbin.info/www/bejne/o6Oleq2XqdqIiLM

[@RahulKumar-mc4dg]

Don't have words to express how amazing your explanation simple and satik

[@Innozant]

Thanks...Happy New Year to you and Your family 🙏❤️

[@RahulKumar-mc4dg]

@@Innozant You too

[@VimalKumar-ih6ik]

concept clear...thanks

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@crazyff4436]

sir aap dekhna bahut jald 100k ho jayenge 🙂🙂

[@Innozant]

Thanks dear.. keep Learning ❤️👍

[@crazyff4436]

@@Innozant Sir ek doubt tha ham job kaise search karenge excel ki

[@muhammadhuzaifa4521]

You are great sir

[@k.l.narsimharao5668]

Sir, how to remove the VBA code excel work book or excel shhets

[@RajniSingh-ye4sn]

Sir good morning, ur all videos are very helpful.mid formula is still confusing please tell us any easy way please.

[@Innozant]

Try it using replace function

[@arindamhazra2300]

Love your dedication... Thanks..

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@patels2549]

way of teaching is outstanding, mind-blowing i really really appreciate sir mera kal sr mis excu. ka interview hai maine aapki almost saari video dekh li bs sir due to laptop i cant practice but it will be help thank you so much god bless sir aur bhi video uplaod kero ji 🙏🙏

[@Innozant]

Thanks dear...ydi practice kiye hote t8 sachme baat alag hoti...anyways..Best of luck..jaisa bhi ho btana dear

[@patels2549]

dear sir interview was good but i am not selected but learn something sir mere sei iska anser nhi nikal rha to please help dear sir can u please tell us how to extract all data like(emp_name, Designation,emp_id,tag_number,sales_amt,emp_state) from master sheet to another sheet through Emp_Name (In Emp_name coloumn also duplicate name)

[@rahulshinde4600]

Sir, R0231 Rahul Enterprises ( Mumbai) Iss main R0231 alag cell main and Rahul Enterprises (Mumbai) ek hi cell main rakhna hain. Pls help me.

[@arbaz4391]

Sir how can we split a column if it has frist name middle name last name and employee id in it...plz help

[@Innozant]

You want formula for this or using text to column ?

[@sandipkherade7523]

Sir isme jab second time +1 karte hain vahi jagah pe agar -1 dala to bhi result sahi aata hain. Is it right or wrong?? Mine karke dekha

[@battlefansshorts8941]

Nice 👍 sir

[@Innozant]

Thanks Ravi Ji🙏❤️

[@makrandkadam2127]

Great Sir, Thank you very much for explaining

[@ramkishoryadav9087]

kzbin.info/www/bejne/gKiZqIKapseZiposi=Otfw8HTAk3Cwahi8

[@CareE-Odore]

sir muje Saurabh Kumar Sharma Choyal me se choyal chaiye right and repalce functions se

[@EswarRao-qy5ul]

Wonderful sir

[@sibtainmushtaq4387]

Sir g evaluate ka option kistrah aiy ga mid waly function main

[@Innozant]

Using F9 key