Split Full Name to FIRST, MIDDLE and LAST Name in Excel with Formula│LEFT RIGHT MID and FIND Formula

[@sudeshrajkumar7664]

Sabse best apka raha ,splitting name video,thanku

[@billumamavines3850]

Thank you so much. God Bless you 🙏🙏
New subscriber!!

[@dineshzankar4345]

Bestest Explained 🎉

[@ComTutor]

thanks dinesh

[@bindazsallu]

Very nice video thanks 😊😊😇

[@zishanalam1276]

Simplest way I have ever seen to learn this formula. Great Brother...!

[@althafkhan6179]

One of the best excel teaching video I have ever seen. But this video will be useful for a person who already has some basic knowledge about excel text formulas. But I had some doubs which has cleared now. Thank you and keep posting good videos.

[@ComTutor]

Thanks althaf.

[@rathodshilpa996]

Very well explained!!!!.... thank you ✨✨

[@ComTutor]

Glad it was helpful!

[@thakuranujsingh4419]

Fully satisfied with video and your teaching

[@vikramchhetry7875]

Best explained ! Thanks

[@ComTutor]

Thanks

[@JaiKumar-lz2wy]

Literally excel is the all over game of formulas

[@biplabbaishnab3926]

Well explained brother. I wish I would have watched this before interview.

[@ComTutor]

I took interview for fresher also. And i asked this in my test as well

[@rosariocoutinho8690]

Very nicely explained. I was always getting confused but now with your first space and 2nd space formula it is crystal clear. Thanks a lot

[@ComTutor]

thanks bro please support with subscribe and share this video

[@thakuranujsingh4419]

Gjb video and it's too easy

[@pratapbisht1]

Very Nicely explained

[@rosariocoutinho8690]

Very good explanation

[@sonumamtora5110]

Very Nice Brother

[@ComTutor]

Thanks i think you completely understood this formula. This is very difficult to understand at once.

[@MohammadImranImu]

Your Supportive talk and your video both are good. Thanks.

[@ComTutor]

thanks.

[@joe21lester]

Very visual explanation, easy to understand and remember......Thank you Sir.

[@ComTutor]

Thanks

[@sksalman2748]

No one teach this concept as compared to you sir you are awesome

[@mohdrahis5738]

Nice Video, you got the right way to make us understand, I have watched some videos but I didn't understand why all the stuffs we are using which have used in this formula you made it thanks a lot.

[@adhikarisuraj9100]

GOOD ONE BRO

[@shubhina18]

awsm job.it really very very helpful sir....

[@bimalsuna156]

Sir aap ka explaination bohot acha laga mujhe chahiye practice sheets kaise milega?

[@nikhilverma8778]

Bhai bhut hard hai prectis bhut jaruri hai

[@abhijeetpatil055]

Very useful

[@ComTutor]

thanks

[@magbulmansuri4636]

VERY GOOD

[@ComTutor]

thanks

[@bisagesoftware9494]

I liked any youtube tutorials for the first time. Thanks for your guidance to get solve long pending issues.

[@mohdaftab7444]

Really very helpful

[@ComTutor]

thanks

[@creativ.nation]

Great 👍

[@ghurahuprasadyadav3798]

Respected sir ,
Thanks for sending copy .

[@ComTutor]

your welcome.

[@pravinpoojary4739]

Please share sheet for practise nice one bro

[@shalurajrajora2250]

Sir your video is very helpful.....
But meri ek query hai plz solve my problem...
Agar mujhe satya raj wale word me se Raj word ka R chahiye to wo kaise find hoga...
Sir plz give me an answer of my question..

[@ComTutor]

agar only sayta raj 2 word hai to R ke liye app right wala formula apply kar sakte hai.

[@shalurajrajora2250]

@@ComTutor
Right wala formula apply karke dekha...but output thk nhii aaya....mujhe Raj word me se sirf R find karana h....plzz kya aap formula likh kr bata skte hain

[@tinkughosh5561]

Awesome

[@ComTutor]

thanks.

[@KumarAnalytic]

Bahut achchi

[@prachi.3007]

Brilliant work. Can you share this excel file? I don't know why i'm getting some error with last name formula.

[@ComTutor]

your Email ID.

[@MakkiDarulHikmatDawakhana]

really nice technique, I like it.

[@ComTutor]

thanks.

[@abdullavazhayil4868]

Music could have avoided... It distracts attention...otherwise a good informative video... Remove music and upload... Never add music to this kind of informative video... It is a request... There are lot of music video in youtube for music lovers...this is best video describes left, mid, right i have ever seen, reupload without music... Music disturbs a person like me who have hearing problem ..

[@rajeshchoudhary2520]

Very High Video

[@pinkyshrivastava3234]

Thank you sir

[@ComTutor]

your welcome.

[@robertbarker2023]

This is the closest solution to my problem. What do you do if some names have a suffix? Not all names have a middle. You may have a John Smith and A John Z. Smith Jr.. Thanks

[@aijazali5217]

good job....par background music chalana zaroori hai kya...

[@swapnapawar7676]

For separating last name we can also use =RIGHT(A2,FIND(" ", A2))

[@ComTutor]

yes but it only for 2 word name. means for first name and last name only.
its not apply on middle name wala formula.

[@shivagamipillai8470]

Thanks

[@enlighteningbrain8247]

Its Wrong , you won't find last name by this formula

[@IndusUstvbharat]

Osm

[@sumitsaraswat5884]

Good job...it is really helpful...thanks a lot...I have a question what if there is fourth name ..I faced this situation in one of my interview..please if you have solution.please provide

[@muneebtariq817]

Sir mein nay apka channel dekha us mein apki excel ki videos bht pasand ien hai achay tariqay se samjatay hai ap.
Sir Mera Aik masla hai name ko split karna ka please kafi logo se pocha hai par sai tarah se reply nahi mila ap se request hai k meray is query pay aik video bana di kyun k mujy excel mein bht pareshani hoti hai office k kaam mein. Mein apko isi comments mein kuch name likh k deta hun tah k apko mera question smaj a jae.
For example
Nouman Ali S/O Abdul Rasheed (mein chahta hun k Nouman Ali pura name aik cell mein isi tarah S/O aglay puray aik cell mein aur Abdul Rasheed Pura Aik Cell mein a jae mujh se yeh nahi ho raha hai)
Muneeb Tariq Mughal S/O Tariq Mehmood Mughal (mein chahta hun k Muneeb Tariq Mughal pura name aik cell mein isi tarah S/O aglay puray aik cell mein aur Tariq Mehmood Mughal Aik Cell mein a jae mujh se yeh nahi ho raha hai)
Abdul Sattar Edhi S/O Satttar Khan Edhi (mein chahta hun k Abdul Sattar Edhi pura name aik cell mein isi tarah S/O aglay puray aik cell mein aur Sattar Khan Edhi Pura Aik Cell mein a jae mujh se yeh nahi ho raha hai)
Khalid Mehmood Abbasi S/O Mehmood Khan Abbasi (mein chahta hun k Khalid Mehmood Abbasi pura name aik cell mein isi tarah S/O aglay puray aik cell mein aur Mehmood Khan Abbasi Pura Aik Cell mein a jae mujh se yeh nahi ho raha hai)
Please sir yehi waly name lay k aik video bana day mein ap k response ka intezar karunga shukriya.

[@IrfankaConcept]

Plz give me sheet sir... Thanx for video

[@ComTutor]

you mail

[@indrapalsinghwakre2382]

Pls Sir to make about tally video

[@virendersingh5978]

Sir agar muje apne name ka only first word of first name and first word of last name separate karna hai to kaise karenge ......
Jaise mera name hai virender singh,,, orr muje only V column 1 me and S column 2 me karna hai to kaise karenge
Please tell me

[@aminpinjari4070]

How to write three letters out of surname in excel sheet, which formula should be used

[@SandeepRawat-zn7ov]

I have some data like
I am Sandeep from Delhi
Please find the position " Sandeep"

[@ComTutor]

if your line "i am Sandeep from Delhi" in A1 cell then apply below formula.
=FIND("Sandeep",A1) it will show you location for sandeep.

[@SIMRANKAUR-eg7nc]

Find the first space " " and then extract with left accordingly.
Or better use text to column.
ua-cam.com/video/RhamuSEieQ0/v-deo.html

[@RAKESHKUMAR-fz1yw]

I like the vedio a new formula may you mail the sheet

[@johnphilips6535]

What is use of Ist Space and 2nd Space?

[@bharatkudache]

How to use MID formula For Pan card Application form

[@ComTutor]

bro MID formula only picks the middle value. so in Pan card which value you want to pick, choose accordingly and apply the formula.

[@bharatkudache]

ComTutor sir give me u r email id i send pan card form u see it

[@ComTutor]

[e-mail]

[@oslewis1911]

What if in a range, one Name has no Middle name & Last Name

[@DILIPPATEL-ou5hh]

sir patel dilipkumar jayantilal ko short me patel d.j short me likhne me konsi formula ka use hota he

[@shivagamipillai8470]

Sir aap acha sikhate ho,per bohut speed me jaate ho isliye kuch samaj hi nhi aya mujhe,sir pls next video thoda slowly samjhana pls

[@ComTutor]

maine itna slow samjhaya hai tak jakar mera video 10 mint ka hai. ab isse slow karunga to ye kafi lenghthy ho jayega phir koi bhi mera video nahi dekhega.

[@kamalgoyal8780]

Background music jyada tej bajta hai

[@ComTutor]

Sorry ab se kam kar dunga

[@muhammadaltaf753]

Sir agar Name & Father Name ek hee column mein likha hooo aur father name alag karna hooo toh kyaakrna hoga
e.g Rajesh kumar s /o Brijesh kumar
Rajesh kumar say aga wala potion hume alag karna hai s/o ka sath toh kya karna hoga
Ya s/o saa hume delete karna hoga toh kya karna hoga plz help as soon as possible

[@saiprasadkalluri7610]

What if we don’t have any space ? for example: Kareenakapoorkhan

[@himanshu_sahu_007]

Middle name jaruri hota hai kya
Meri 10th ki marksheet me meri mother ka middle name mention nhi hai

[@everwilling1009]

osam

[@ComTutor]

Thank you Very much

[@abdullavazhayil4868]

Music deviate attention....

[@zishan7852]

How to Make attendance sheet in construction compny plese make next video

[@ComTutor]

okay i'll teach attendance sheet.

[@vishnubhaipatel3306]

Time 300:30/5:15 h:m how

[@TIE-TakeItEasy]

what if there are 4 words or more in a name?

[@thakuranujsingh4419]

What Will be do if only first name available

[@ankitshakya7]

Plz sir ye sheet mujhe email kar dijiye very very useful

[@SandeepRawat-zn7ov]

3 space ko Karna shikaye

[@ComTutor]

teen space ke liye ek aur find and search ka formula add ho jayaga

[@sabujdas9842]

Sabuj Das

[@ComTutor]

your mail id

[@shammikapoor5673]

shammi kapoor ka middle name kiya hoga

[@ComTutor]

middle name usme hota hai jisme do baar space aata hai yha koi middle name nahi hai first name and last name hai only

[@paramjeet975singh3]

agar aysa hota hi madhuri dixit nene to kaise karte matlab bahut sare spaces ho ?

[@excelmaster1328]

Kindly Remove background music

[@mohammadjunaid1002]

Background sound is too loud

[@ParabAmol]

कुछ नहीं समझा.... अब excel कभी nhi use करुंगा

[@ComTutor]

samjdaar ko ishaara kafi hota hai.......

[@ParabAmol]

@@ComTutor 😄ये कहा कि line कहा use किया... इशारे 😄

[@mohammadirfan8355]

Mera naam Mohammad irfan hai to isme sir name Or first name kya hoga

[@ComTutor]

irfan is your last name. and rest is first

[@Akhelsa47]

Stir ek data hai usme sabhi ke naam hai muje vlookup se unke naam ke digit chahiye tho kaise hoga

[@ComTutor]

=LEN(cell aderess) use kro.
ye len ka formula kaam karega.

[@Akhelsa47]

Sir vlookup phle lagana hai Kya

[@safeerahmed4474]

Sir what If the name is like this Mrs Alia Smith Alexander . Mrs will be the first name and I need the last name as Alexander please help

[@ashishrathor5749]

if there is no last name or middle name than its show #value how can we resolve

[@mizanurjihad2440]

sir my name is Muhammad Mizanur Rahman Which is first name which is last name?

[@ComTutor]

Muhammad is your first name and rahman is last

[@lggamingmahesh4232]

Bhai mera name ka middle name kar do plz

[@ComTutor]

apke naam ke liye 4 formulo ko combine karna padega.

[@hiteshdamania2744]

Pls share me the sheet siji

[@PawanKumar-sx3ok]

Agar name pawan singh Baghel rajput ho to middle name kya hoga

[@mayanksaini1411]

Plz send the sheet

[@ComTutor]

check.

[@malawmisaiha7500]

sir, pliz sen me school management Thanks.

[@ComTutor]

school management ka kya send karoo. please clear your question.

[@avinashphadnis2379]

Please control music

[@ComTutor]

you are the 1st bro among 2000 viewer who said about music. okay, it'll reduce it in next video.

[@silajitdey1760]

Why background music!! Very bad indeed.

[@spchoudhary14]

My name is SATYA PRAKASH
Sir isme first name or last name btaye

[@ComTutor]

suppose your full name is in A1 then wright below formula in b1 cell for 1st name and c1 cell for last name.
Write in B1= First Name : =LEFT(A1,FIND(" ",A1)-1)
write in C1 = Last name : =RIGHT(A1,LEN(A1)-FIND(" ",A1))
now drag this formula in the whole column.

[@spchoudhary14]

You mean sir
First name :- SATYA
last name :- PRAKASH

[@ComTutor]

write your full name in A1 cell, then ooper jo formula diya hai b1 mai left wala paste kar do aur c1 mei right wala.
tumhara answer aa jayega.

[@naveenjoshi8618]

Please sir mail kar dijiyega sheet

[@mohammadirfan8355]

Sir my name is Mohammad Irfan which is sir name and last name

[@viteshreddykara4673]

My name is K SAI VITESH KUMAR REDDY in this which is my first n middle n last name..help me

[@ComTutor]

your first name would be K SAI VITESH
middle name KUMAR
last name REDDY.

[@seekhoseekhayo7260]

Sir Mid ko formula or bta do..

[@ComTutor]

mid ka formula isme bta chuka hoo.

[@delhicreationpoint1590]

Background music ne is very wroste

[@mayanksaini1411]

Com sorry

[@ComTutor]

oaky

[@shammikapoor5673]

btao bhai middle name mere naam ka

[@ComTutor]

dost middle name nahi hai, kya aap apne naame mei do space lgate ho. nahi naa.
aur middle name mujhse kyo puch rahe ho main koi pandit ya jyotish hoo kya.
apki agar koi query hai to comment karo. nahi to koi baat nahi .

[@Akhelsa47]

Aap +1kyu likhe

[@ComTutor]

taki phele space ke baad ki value count ho.

[@mohammadirfan8355]

Plz write

[@bkmallik3097]

banamallik9457

[@ashvinchorasiya]

सर मुझे
Ashvin Mohanlal Chorasiya को सिर्फ Ashvin Chorasiya लिखना हो तो ये कैसे किया जाता है बताइए
[e-mail]

[@ComTutor]

okay aap excel ke A1 cell mei apna pura naam likhe aur neeche diya hua formula B1 cell mei paste kar dijiye ho jayega.
phir isi tarah iss formule ko neeche drag kar dijiye. wo sab par apply ho jayega.
=LEFT(A1,FIND(" ",A1))&RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1)+1))

[@shrutee28]

You are too fast

[@ComTutor]

sorry but if i go slow my video will go about 15 to 20 minutes. that's why it is fast. but you can see by play and pause.

[@mohammadirfan8355]

Plz reply