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

Подписаться 155 тыс.

Просмотров 34 тыс.

50% 1

MID Function दोबारा | Extract First Middle and Last Name without Using Left and Right Function
Excel Maharaj For Experts- • EXCEL MAHARAJ - For Ex...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#midfunction #excelformula#innozant #excelformulasnadfunctions

Опубликовано:

6 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 182

@nitinshukla914 3 года назад

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

@Innozant 3 года назад

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

@jayantabhattacharyya628 3 года назад

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 3 года назад

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

@tejpalsain1507 3 года назад

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

@Innozant 3 года назад

Thanks Tejpal ji😀❤️

@sandeepaswal8944 3 года назад

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

@Innozant 3 года назад

Thanks Sadeep Ji..Happy Learning dear

@shivii88 10 месяцев назад

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

@rjchoudharyacb 6 месяцев назад

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

@Innozant 6 месяцев назад

Thanks..Keep Learning..Keep Growing

@Kingpotash Год назад

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 😊❤️

@surenderverma8959 8 месяцев назад

sir, aap bahut badiya bahathe hai thank you sir.

@sushmapandey7718 3 года назад

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

@Innozant 3 года назад

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 3 года назад

@@Innozant ok sir😊

@Aghast88 3 года назад

Your teaching style is great...

@Innozant 3 года назад

Thanks Santanu🙏❤️

@rahulkashyap2704 3 года назад

Really really easy Thanku SR ji 👍

@Innozant 3 года назад

👍❤️🙏

@satishojha6240 3 года назад

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

@Innozant 3 года назад

Thanks Satish Ji..🙏🙏

@Indian-tech 3 года назад

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

@Innozant 3 года назад

Thanks dear

@faheemkhan7275 2 года назад

Very nice and informative formula. Thank you

@Innozant 2 года назад

❤️👍

@neerajdevtalla7148 3 года назад

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

@Innozant 3 года назад

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

@VlogAvi 2 года назад

thnx sir for the betterment of all the learners

@rahulkashyap2704 3 года назад

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

@Innozant 3 года назад

Thanks Rahul .keep it up dear👍❤️

@merapatients85 Год назад

Trust me king of excel love you sir really kings

@Innozant Год назад

Thanks.. Really means a lot to me

@Narendar.pathak 3 года назад

Thanks sir you videos always motivate and help ful

@Innozant 3 года назад

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

@LovlyAmit Год назад

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

@rahulkashyap2704 3 года назад

It's really amazing sr ji 🤓

@Innozant 3 года назад

Thanks Rahul Ji .Happy Learning

@Kingpotash Год назад

Thanks, it's a super duper hit formula

@Innozant Год назад

Thanks

@dilipmondal5575 3 года назад

Great Learning Platform.....Thanks Sir.

@Innozant 3 года назад

Thanks Dilip Ji❤️

@amitapattanaik1071 3 года назад

Very good stylist logic, Maza agaya

@Innozant 3 года назад

Thanks Salil ji

@PrabhakarKumar-hb8so Год назад

Thankyu Sir Samjh Mai Aa gaya

@balance1772 Год назад

You are my Gurudev🙏🙏🙏🙏🙏🙏🙏

@sajjadhussain3899 3 года назад

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

@Innozant 3 года назад

Thanks Sajjad..Happy Learning ❤️🙏

@kishorpanara4191 3 года назад

Ye to super se bhi uperrrrr hai Sir Thank you sir

@Innozant 3 года назад

Thanks Kishore ji .Good Night

@radheprajapati2036 3 года назад

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

@Innozant 3 года назад

Thanks Radhe Prajapati

@johndas8173 3 года назад

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

@hsgusain2054 3 года назад

Yes

@Innozant 3 года назад

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

@gautammishra6395 2 года назад

Wow,,, awesome trick sir

@Innozant 2 года назад

Thanks Gautam.Happy learning ❤️

@devmgr500 Год назад

Thanks

@ITTrainerSofcon-Sec6 Год назад

very good

@sridharkrishnappanavanerth3388 2 года назад

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

@gulshanmehta6997 3 года назад

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

@Innozant 3 года назад

Thanks Gulshan.. Happy Learning

@Sarita_Classes Год назад

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

@Innozant Год назад

Hahaha.. Thanks

@johndas8173 3 года назад

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

@Innozant 3 года назад

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

@manojkumarsingh3385 3 года назад

You are amazing sir 🙏🙏🙏

@Innozant 3 года назад

Thanks Manoj ji

@manojkumarsingh3385 3 года назад

Very Interesting Sir

@Innozant 3 года назад

Thanks

@hsgusain2054 3 года назад

Thanks Sir

@bishtlokesh1297 3 года назад

Wow 😳 amazing 💖💖🤩🤩 mja aa gya

@Innozant 3 года назад

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

@createyour6681 3 года назад

Very great sir

@Innozant 3 года назад

Thanks

@theblackhawk111 Год назад

Suspense hi suspense...👍👍👌👌

@Innozant Год назад

Still suspense ... Repeat the video again

@uditya.araya.s 5 месяцев назад

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

@nandinisharma7008 2 года назад

Excelente sir 😀👌👌

@Innozant 2 года назад

Thanks Nandini.. Happy Learning ❤️👍

@humayoonshah6157 6 месяцев назад

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

@hiteshchourey9730 2 месяца назад

Ye function best hai.

@deepraazshaw7369 3 года назад

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

@Innozant 3 года назад

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

@MohammedAli-yk3fd 3 года назад

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 3 года назад

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

@maheshswami2064 3 года назад

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 3 года назад

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

@RahulRoy-po9ct 9 месяцев назад

🙏

@deepraazshaw7369 3 года назад

Sir apke Proquest vidoe Ka intazar hai sir.

@Innozant 3 года назад

Yes..Coming sunday again

@koushikmaity3954 3 года назад

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

@Innozant 3 года назад

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

@PraveenKumar-el8ty 3 года назад

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

@VikasSingh-sv9bp Год назад

Sir concatenate ke formula mein link kaise add karein

@VlogAvi 2 года назад

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 2 года назад

Great ..Keep it up..👍♥️

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

@AshishSingh-hg2gc 3 года назад

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.

@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

@paramjeet975singh3 3 года назад

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

@Innozant 3 года назад

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

@dilipmondal5575 3 года назад

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

@Innozant 3 года назад

Which data ?

@dilipmondal5575 3 года назад

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

@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

@ARIFSAIFIFARHAN 3 года назад

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 3 года назад

can you please explain this phenomenon of MS Excel platform

@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

@abhisekmohanty23 2 года назад

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 2 года назад

Kindly watch excel maharaj play list for the same

@nikhilmore6129 3 года назад

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

@Innozant 3 года назад

Thanks Nikhil Sahab

@awanishanurag1763 Год назад

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

@tejpalsain1507 3 года назад

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

@Innozant 3 года назад

Thanks Tejpal..Daybook Dashboard bnatabhu free time me

@pa2happiness13 3 года назад

💞👌🏼

@johndas8173 3 года назад

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

@Innozant 3 года назад

Acha

@parthmalik3004 Год назад

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

@durgeshrai8938 3 года назад

Nyc

@rajkumarprajapti6821 2 года назад

Sir agar cell me 4 text hain to kaise karenge

@kg1980 3 года назад

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

@Innozant 3 года назад

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

@kg1980 3 года назад

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

@sonukumarskp6933 3 года назад

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 3 года назад

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

@tarjitmalka3978 3 года назад

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 3 года назад

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 3 года назад

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

@ayushsinha_1324 3 месяца назад

Sir please thoda baate kaam kara kariye 🙏

@ajitsharma4676 3 года назад

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 3 года назад

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

@ajitsharma4676 3 года назад

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

@ravienterprise3682 2 года назад

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

@shaikhyaseen8322 2 года назад

Use text to colum which already available in excel itself

@abdullavazhayil4868 2 года назад

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

@Innozant 2 года назад

Kindly watch Text maharaj series for this

@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

@MAHESHKUMAR-fp7cn Год назад

Sir I have no middle name than how can I exit

@muhammadsaqlain5162 2 года назад

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 2 года назад

Ok..kisi upcoming video me explain kar denge

@muhammadsaqlain5162 2 года назад

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

@gauravbhatia7987 3 года назад

🙏🙏🙏🙏

@mayursaini27 2 года назад

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

@Innozant 2 года назад

Nhi dear ..usse nhi hoga

@mayursaini27 2 года назад

@@Innozant फिर kya karengey

@epicclashers2946 7 месяцев назад

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

@Innozant 7 месяцев назад

Means?

@epicclashers2946 7 месяцев назад

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

@ghumansaab2314 3 года назад

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 3 года назад

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 3 года назад

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

@paramjeet975singh3 3 года назад

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 3 года назад

Dubara chrome reinstall krke dekhiye ek baar

@paramjeet975singh3 3 года назад

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

@nehadave9103 2 года назад

Asariminabensureshbhai ise kaise alag kar sakte

@Innozant 2 года назад

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

@amitjha6163 3 года назад

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

@Innozant 3 года назад

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

@Ann_2208 2 года назад

255 ka logic kiya hai guru ji

@Innozant 2 года назад

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

@manojkumarsingh3385 3 года назад

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 3 года назад

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

@manojkumarsingh3385 3 года назад

@@Innozant Sorry sir Hum nhi Kar pate hai

@ajitsharma4676 3 года назад

Please help.

@SinghSahab-gg1ow Год назад

Sir

@Innozant Год назад

Yes Ajeet ji

@tarjitmalka3978 3 года назад

⭐⭐⭐⭐⭐

@rekha3280 3 года назад

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 3 года назад

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

@rekha3280 3 года назад

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