Split Full Name to First name Middle name and Last Name in Excel Bulk name split in excel formula

[@mdsahaburrahman237]

really your formula is perfect than others i have checked many of them but i like it.

[@jyotirajput3980]

Thanq so much sir. Apne bahut achha explain kiya

[@durjansanta8820]

Bhai ey formula muje bahat easy laga batane kilie thankyou so much

[@JayshreeKumavat-yz5kk]

Thank you... This video is very useful 😊

[@pathani.k8443]

Thanks 👍.. so much helpful...

[@surbhijaiswal3209]

thank you so much. it really helps me.

[@yousafraza2890]

Love you my bro i got a project worth $50 need to separate 50k names. After watching your vid i done it in less than 30min. Love you God bless you always i can’t explain my feelings right now

[@yousafraza2890]

And guess what client ne $60 bonus bhi diya

[@bohemian5964]

Where to get such projects bro? Kaha milega?

[@yousafraza2890]

Fiverr

[@ashishdubey3256]

Yousaf Raza how can find project plz tell me brother

[@sanjaybhalekar9734]

valuable information thank u sir

[@excelmaster1328]

Nice video Sir U are some specialty for me

[@muhammadwaqas7018]

good work bro

[@VinayRawmzp]

Dhanyawad sir ji

[@jessaloriebalucas9966]

Got it! Thanks for the help ❤️

[@SUVAYAN_DAS]

Good one👍👍

[@kishorpagare2784]

Useful 😊

[@kartikienterprises]

THANK YOU SO MUCH TEAM, ITS USEFU FOR ME👍

[@SUVAYAN_DAS]

Thank You So Much 🥰🥰

[@arun_maiyaniofficial]

Thanks👍👍👍👍👍👍

[@bharatpokharel6032]

thank you so much sir

[@gauravsupekar219]

thnak you so much sir

[@rheajobin06]

Thank you sir for explaining to me!!

[@sumangurjar1087]

Thanks bro

[@jatinkumar7946]

Excellent video

[@varshanandgoankar9198]

Very helpful thanks sir

[@SourceofLearning]

Great work sir. Excellent content, keep it up👌👌👌

[@mdhabibullahsk781]

Very good.

[@rimalabista2397]

Thanks for help.

[@ashishkumaryadav7899]

To mai ap sbhi ko batana chahunga ki jo formula laga hai last name usi ke aage apko if lagana hai aur fir formule ke last me = aur fir jis cell me first name hai use select kr lena hai fir coma(,) lagana hai uske bad jo formula pahle laga tha usi ko copy paste kr dena hai pr usme if ka formulas hata ke then bracket close and enter... Fir 100% data automatically populat hoga koi changes ki jarurat nhi padega

[@rheapeter9709]

Thank you sir!!

[@chaitanyakanoriaofficial]

Gazab 👌👌

[@Anup8636-c2g]

Good job sir 👍

[@sarfrazahmed249]

Super

[@AvinashKumar-jn9oj]

Awesome formula sir

[@amolkhokale7907]

Gr8 Sir

[@Businesswarrior3169]

Bohut acha

[@amitchakre3794]

Super sir

[@rishikaramwala3498]

nice video

[@funnydev818]

God job sir

[@lonipravara2236]

thanx

[@PRADEEPSHARMA-fe3jx]

very good

[@mridulkalita1746]

NICEEE

[@vikasbl2900]

Tq

[@mdniem3592]

hello bro

[@SaurabhSharma-ry8iz]

Mast video

[@maymunacadey7500]

Thank you

[@optimistic7700]

Flash fill is far better that this. With flash fill you can easily extract data in just 15 seconds. No problem how big data is. Just use flash fill. :)

[@Nayeemislam1999-c1w]

wow

[@ashishkumaryadav7899]

Ye bhi ho sakta hai agar single name hai to bhi manually space ki jarurat nhi padega aur agr hamara data source bada hai aur 100+ single name hai to manually space dena lengthy process hoga aur interview me data sources change karna allowed bhi nhi hota

[@tinkutinku7879]

Usefull but dear is elder .

[@asimbaba7990]

Sir how can we divide a big name i.e 4 to 5 words into only in two cells equally?

[@sachinkumari4277]

Nice video but ek problem aa rahi h agar main name ke starting mein space deta hu toh result show nhi ho rha h

[@sayyednaushadfaiyaz]

If LName is not there then use below formula. =IF(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",100)),100))=TRIM(LEFT(SUBSTITUTE(A2," ",REPT(" ",100)),100)),"",TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",100)),100)))

[@MrVISHUSAHANI]

☺️👍 में विजय बोल रहा हु ??? है अगर row में एक नाम के 3 बार आये तो फ़ास्ट सेकेंड थर्ड के लिए कोंन से फार्मूला होगा दिखाएंगे ????...💐💐💐

[@LoveAllMyFamily]

Bro can you explain the formula for the middle name, please?

[@MrVISHUSAHANI]

☺️👍 में विजय बोल रहा हु ??? है अगर row में एक नाम के 3 बार आये तो फ़ास्ट सेकेंड थर्ड के लिए कोंन से फार्मूला होगा दिखाएंगे ????...💐💐💐 प्रश्न है मेरा की जब Row me एक साल के 12 महीने के फ़ास्ट सेकेंड थर्ड पेमेंट सेम हो तो कैसे दिखाए जैसे :- उदारण जनवरी 25000 फ़ास्ट मार्च 2500 सेकेंड अगस्त 2500 थर्ड दिखाना हो तो सेम पेमेंट ओर एक Row में ही तो कोंन से फार्मूला हो -???☺️☺️💐💐

[@raamsrinivas7662]

i have a database of 20k lists having names like, A K Rajaram Dr. Sumathi Ak Rao PM Yadav i think there's no method to sort it

[@ashishkumaryadav7899]

Soiry bich me ek step miss hua hai coma (,) ke bab dual cot (""), lagana hai fir formula copy paste karna hai

[@anujrai9319]

Sir attendance counting with over time hr and salary sheet kis trh create kra

[@Abhisheksharma-zw2vx]

Sir, Barfi Devi c/o Handu Singh mai c/o ko hata kar sirf ek coloum mai Barfi Devi aur dusre coloum mai Handu Singh kesie likh sakte hai plezz bataye.

[@Worldofnyza]

Bhai.. Please help with a formula to seperate 4 names into first, middle and last name

[@arsalansayyad1045]

For first name =IFERROR(LEFT(A2,FIND(" ",A2)-1),"No first name") for Middle name =IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))

[@DineshSoniyana]

3 आदमी है A ,B, C 1. महीने की 15 तारीख को सभी जने 100 - 100 ₹ जमा करते है 2. ये योजना 10 वर्ष की है 3. जरूरत के अनुसार ये लोग उसी जमा मेसे ऋण लेते है तथा किस्तो से वापस जमा कराते हैं 4. इन्हीं जमा में से सामूहिक भर्मण भी हो सकता है तो इसका exel kaise banate hai। हिसाब रखने के लिए।

[@abhishekjena6317]

Sir point of sale banao

[@ManojKumar-zg6yc]

Will u make a video in excel 1114/6 the reminder shown in seperate and another q firstly 1114/128 balance divided by 16 and bhagfal shown seperate if possible pl be urgent

[@NBs304]

How you name FMS .. N. Bhaskar this is the initial with name plz reply

[@kishorpanara4191]

Sir pura formula samjaye

[@sussyvida6491]

Hello what abot 2 names, 1 middle names and 1 last name ???? Like Cesar Ruben Rodriguez Perez ??

[@C-TECH]

yes , What can the two names also be known

[@maheshkumar9945]

Mera naam om mahesh kumar yadav hai iska kya ilaz hai

[@jhangir1]

Sir Mera name. (Jhangir Akhtar) or father name (Mohammed Amin) ha to.sir name Kia ho ga.plz reply sir shukria.

[@CHAPPiE18]

If Name is Manoj A K What's the; First Name Middle Name Last Name

[@excelmaster1328]

If i have to seprate 500 name to find first name Then i have to input 500 in the formula of first name Becos aapne 100 input kiya tha ?

[@parthmalik3004]

Ab middle name and sir name ke formule kaam nhi kar rahe hai

[@mdniem3592]

Plij plij plij. Help uu

[@mdniem3592]

Amar ekta kotha silo apnar sathe

[@Lovelytwins2428]

Mohd mera surname Shahid mera name My full name is MOHD SHAHID How to fill it. Very confusing

[@mohammediprakimdiprakim.294]

Supply cut?

[@tarunpathare5232]

Bhai video se jada to ads hai

[@makbulansari2255]

Begam, BIBI. KHATUN KYA HOGA

[@ihsankhan246]

Bhai mera naam ihsanullah hai Mera is name ka last name kya hoga

[@All_about_motivation969]

Ishan Lulla hoga.

[@Pixindesign]

Samjhaye hi nahi bhai. Bolte ho yaad kar lo

[@radheybhaiya515]

Kaam nhi kar hai Hai ye formula

[@AsifAli-ro2vo]

Formula smjha toh deta

[@santanuroy4933]

Not working

[@priyankabhineet2715]

Sir Channel Name me "C" matlab kya hai?? 🤣🤣🤣

[@uniquemobiletipstricks7714]

कंप्यूटर tech

[@mosin920]

Bhai new aadhar action nhi mila h tumarai dusrai chenal pr plz link do mujhai aadhar action new ka plz

[@C-TECH]

abhi nahi hai

[@mosin920]

@@C-TECH plz bhai new aadhar action video bna dijiyai

[@niteshkarya1247]

Tumahare baska nahi h sikhana

[@KirtiDokrimare]

Thank You So Much!

[@shahbazawan418]

Excellent thanks

[@arvindprajapati6850]

Thanks bro

[@lokanathmahapatra6104]

Thank You

[@MrVISHUSAHANI]

☺️👍 में विजय बोल रहा हु ??? है अगर row में एक नाम के 3 बार आये तो फ़ास्ट सेकेंड थर्ड के लिए कोंन से फार्मूला होगा दिखाएंगे ????...💐💐💐 प्रश्न है मेरा की जब Row me एक साल के 12 महीने के फ़ास्ट सेकेंड थर्ड पेमेंट सेम हो तो कैसे दिखाए जैसे :- उदारण जनवरी 2500 फ़ास्ट मार्च 2500 सेकेंड अगस्त 2500 थर्ड दिखाना हो तो सेम पेमेंट ओर एक Row में ही तो कोंन से फार्मूला दिखाना हो-???☺️☺️💐💐

[@yogiyadav1430]

Thanku so much sir