Excel formula for first - middle and last name || Populate first - middle and last name without VBA

Hard formula soft results , Best example Sir.

[@GyanOnTube]

Thank you so much

[@ujjwalchakraborty8840]

Aweasome video sir...thank you for the information

[@GyanOnTube]

Thank you so much for your valuable comment..fo not forget to share this video

[@अंकुरसिंहचौहान-फ9ण]

Very use ful video for me
Very very thank you sir mujhe iski jarurat bhi thi office main
you are great sir
Main aapki sari video apne friend main share karta hu

[@GyanOnTube]

Thank you so much Ankur for your valuable comment..means a lot to me..thank you for all your support

[@education55953]

It's very helpful video for us. Thanks a lot Sir.

[@GyanOnTube]

Thank you so much

[@Ajay_Pal00143]

you have a great knowledge sir 😊

[@GyanOnTube]

Thank you so much

[@Altaf_Alam]

Nice explanation sir ❤️❤️

[@GyanOnTube]

Thank you so much 🥰..do not forget to share this video

[@ganesh6283]

Very good bro.. thank you for sharing this trick

[@GyanOnTube]

Thank you so much

[@nooralamansari8287]

Nice Video
Your all videos are Knowladgeable and informative,
Your way of teaching is too Good
Thank You Sir for teaching us via making UA-cam videos.

[@GyanOnTube]

Thank you so much...do not forget to share this video

[@sureshprabhu5711]

I had tried text column . this is logical and skilled thank u

[@GyanOnTube]

Thank you...

[@manojindrasan95]

I personally very very great full to you for make to this video. Hope scuh type of video will helpful to all. Thank U

[@GyanOnTube]

Thank you so much manoj ji for your valuable comment..keep supporting

[@jaliil225]

Mujhe kuach shamj nahi aara hai 8 fail hun

[@chahatgarg3256]

Thanks. Beautifully explained

[@GyanOnTube]

Thank you so much

[@muhammadkhalil5712]

Excellent. 👍👌😇❤️

[@GyanOnTube]

Thank you so much 🙏

[@iamdeepaksasmal]

Sikhaate ache se ho ... Main South Korea se aaunga jab bhi zarur autograph lena cahunga

[@GyanOnTube]

Aap ke comment ke liye bahut bahut sukriya..your comment means a lot... keep learning keep sharing..

[@拆小气]

Really working guys in every situation

[@GyanOnTube]

Thank you so much

[@anuragkumar2072]

Really good thanks sir

[@GyanOnTube]

Thank you so much

[@bulla5078]

Very nice explanation. Thank you 🙏🏼

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@onlyexcel493]

Really sir you explain very well.

[@GyanOnTube]

Thanks for watching Nileshgiri goswami ji..

[@onlyexcel493]

@@GyanOnTube sir offset ka भी video banana & indirect का bhi

[@Curiousitydriven]

explained like explaines to childrens very nice

[@GyanOnTube]

Thank you so much 🙂

[@sachincharde2883]

Great sir thank u so much.🙏🏻👍🏻

[@GyanOnTube]

Thank you so much

[@ajaypundit5060]

wahh sir kya padaya h love you

[@GyanOnTube]

Thank you so much 😊

[@onlyexcel493]

बढ़िया manipulation किया he sir

[@GyanOnTube]

Sukriya Nileshgiri goswami ji

[@varasalakirankumar9933]

Thank you 😊

[@GyanOnTube]

Thank you so much

[@koushikghatak9283]

Wonderful video

[@GyanOnTube]

Thank you so much 🥰

[@aaryanplus]

Very good sir

[@GyanOnTube]

Thank you so much

[@OneSumeet]

Thanks you so much. This is very helpful.

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@OneSumeet]

@@GyanOnTube of course. This is simply great.

[@GyanOnTube]

Thank you

[@krishnkumar7147]

Thankuu sir

[@GyanOnTube]

Your most welcome..

[@ubaidqasim1252]

well done sir

[@GyanOnTube]

Thank you so much. Do not forget to share this video

[@mohanpal13555]

Great vrdio

[@GyanOnTube]

Thank you mohan..do not forget to share this video

[@rjvandan]

Thank you soham ji

[@GyanOnTube]

Your welcome

[@MyBigSupport]

Sir jab me middle name nikal rhu hu to nhi ho rha hai
jaise apne middle name ke liye ak right formula lagaya
aur ak bar left wala hai na but jab me left wala formula lagarhah to jinka name ka 2 alphabet hai osme value error nhi a rha hai osme name nikal ka a ja rha hai me formula ke last me -1 bhi laga rha hu help me sir

[@GyanOnTube]

Aap aapna formula check karke firse lagaoo.. definitely result dega

[@sikandarsingh8716]

Thanks a lot ji thanks again ji

[@GyanOnTube]

Thank you so much

[@Pixindesign]

I subscribed your channel

[@GyanOnTube]

Thank you so much

[@Pixindesign]

@@GyanOnTube pls, sir, make a video on stdev function.

[@GyanOnTube]

Ok sure

[@VinodKumar-mm4rj]

what will be the solution if a person name will be Anna krishnamurti ayappa Kutti, means more than 3 words, pls tell solution

[@GyanOnTube]

Then we need to build another logic

[@ChandanDas-wl2uk]

Sir,, agar kisi ka ek nam hai uske liye kya karna parega...?? For example 'Tamanna'

[@GyanOnTube]

Same formula aaply karo..wo pehele cell mein hi data le lega

[@M.K.Services]

Excellent brother. I need one more help. I have a name on the A1 cell which is like this (Muhammad Khalil) so I want space between these two names like this (Muhammad khalil) thanks and waiting for your answer.😇

[@GyanOnTube]

You want data in two different cells?

[@ronyshafiq]

Make a vedio with this formula like last name as look up value. It will be helpful for all viewer. And also make a vedio with fuzzy match by lookup function. Thanks in advance.

[@GyanOnTube]

I have already made a video on fuzzy lookup..you can check in my channel

[@Mr.KundanThakur]

This formula is very long but good work

[@GyanOnTube]

Thank you

[@rohangamers4]

Thank You

[@GyanOnTube]

Np

[@SKumar-nm7rz]

Very very thanque sir

[@GyanOnTube]

Most welcome s kumar ji...

[@muhammadkhalil5712]

Sir, help me I want space between names I have names in A1 cell like this (muhammadkhalil) so I want space in between two names. With formula only. Please reply

[@GyanOnTube]

No option

[@pratimghosh7925]

I have tried for Short form of a Name like "Raju Kumar Basu" to "R. K. Basu" in excel from inspiration of your video and succeed. But Can not make "Raju Hari Kumar Basu" to "R. H. K. Basu". Can you help me in this? THANK YOU in advance.

[@GyanOnTube]

What Do you wanna achieve

[@pratimghosh7925]

@@GyanOnTube want to make "Raju Hari Kumar Basu" to "R. H. K. Basu" by excel formula

[@GyanOnTube]

Yes that is possible

[@ankushsolanki2770]

👍👍

[@GyanOnTube]

Thank you

[@excelmaster1328]

Sir first name nikalne vath
Sab ka first name tho aagiya but last vale ka #value aara hai
Sir baataye??

[@GyanOnTube]

Aap sahi se formula put karo..

[@excelmaster1328]

Sir usme bola tha space bhi count karega
But us name me only first name hai tho space kha se count karega
#Value hee aara hai

[@excelmaster1328]

@@GyanOnTube ok sir

[@GyanOnTube]

Need to check th function

[@chrismelo9221]

Well explained

[@GyanOnTube]

Thanks 🙏🙏..keep sharing keep learning

[@dineshbhati8941]

Hlo sir I have an urgent work can I contact you ...I want find unique values separated by comma for example: A1: 13,65,34,28, And B1: 67,34,28,77 now result (C1) is 13,65,67,77 bcz 34, 28 is comman so we can't add ..ita my question

[@nitenbajpayee7861]

Sir, Agar sirf First Name enter karu,Without giving space, tab value error aa raha hai.

[@GyanOnTube]

Ok..let me tweet the formula then

[@nitenbajpayee7861]

@@GyanOnTube eagerly waiting 😇

[@GyanOnTube]

Sure

[@ChandanDas-wl2uk]

Hats off sir

[@GyanOnTube]

Thank you so much 🙏

[@TarunKhatri]

thoda tricky hai.
iska koi small formula ni hai kya?

[@GyanOnTube]

Ek do bari learn karoge to ho jaaega

[@jiteshparas3323]

When we have only first name it is not working can you suggest me any formula for that i tried many times

[@GyanOnTube]

Try text split function

[@rajeevmehta9611]

What if the list has only the first name and no middle or last name then what will be the formula. Remember there is no space after the first name because as mentioned there is no middle and last name.

[@GyanOnTube]

This formula will work in that case also...

[@jeetupal409]

Sir But Agar single name ho like only puja to yeh error dera hai

[@GyanOnTube]

Uske liye hamko wild card use karna hoga

[@jeetupal409]

@@GyanOnTube sir uske liye formula likh dijiye

[@shubhamdixit0384]

If u know the shortcut key of this... then plss tell me b'coz it's taking too much time while putting this left, mid & right formula.

[@GyanOnTube]

We can do text to column option

[@iccstudio1106]

Hi Sir need urgently help Cohort Analysis MIS banana h please sikhaa do urgently

[@GyanOnTube]

Sure video prepare kar dunga uske liye

[@iccstudio1106]

@@GyanOnTube pls complete end to end batana buth jruri h Or if possible es sunday se phele bata do

[@GyanOnTube]

Will try

[@alifyamerchant5332]

If name is Mohammad Ali Mohammad Hussain Shaikh then how to do

[@GyanOnTube]

Then we need to tweak the function

[@rankersadda0738]

If name has sharma in his name give him cast as general if name has choudhary in his name give me cast as obc can you give me the formula for this in excel

[@GyanOnTube]

Yes for that you can apply same formula with wild card

[@pklenka10]

If total name is without space how can we remove.

[@GyanOnTube]

Apply wild card to see those

[@hemlata1081]

Hem lata chandr kaise likha jaye ga sir please reply Hemlata Chandra do no ko send ker dijye

[@GyanOnTube]

Agar bich me space hai to ye 3 column mein aaega

[@All_about_motivation969]

Or sir jisme sirf ek he naam ho toh. Usme toh yeh kaam nahi karega

[@GyanOnTube]

Hanji bilkul work karege usme name sirf first column mein hi populate hoga

[@onlyexcel493]

Good job sir

[@GyanOnTube]

Thank you Nileshgiri goswami ji..keep sharing keep learning

[@onlyexcel493]

@@GyanOnTube बिल्कुल sir

[@HASEEBMOHAMMAD97]

SIR SINGLE NAME ME AAPKA YEH FORMULA FAIL HAI VALUE ERROR SABHI ME AYEG AGAR MAI ONLE HASEEB TYPE KRTA HU

[@GyanOnTube]

Aap type karke dekho..wo firat name mein copy kar dega

[@dheerajsolanki9461]

But on interview time we don't have so much time.. Kindly provide short solutions

[@GyanOnTube]

Sure will do that

[@tanyasrivastava6921]

For me, the middle name is not working. It also takes last name when there is no middle name in the full name.

[@GyanOnTube]

Tes, the logic is on that basis only

[@nagarajrao4287]

Thanks

[@GyanOnTube]

Thank you so much

[@bhimravbhaskar5714]

Nice video sir
But first name agar For example MANISH hi ho toh kaise karenge?

[@GyanOnTube]

To wo first mein hi show karega.. 😊

[@shoyebkhan4801]

Agar yhi hume sql me krna ho to kaise krege

[@GyanOnTube]

Kya karna hai sql mein aapko

[@shoyebkhan4801]

@@GyanOnTube sir mere ek column me string data data h jiske bich me numric or alphanumeric ek id hai wo seperate krna h pure column me se

[@GyanOnTube]

Ok to aap power query ke through karwa lo...sql ka data ko call karwa lo power query mein..

[@dhirajnande9748]

can I combine middle name and last name

[@GyanOnTube]

Yes of course just put &" "& and combine both the formulas

[@dhirajnande9748]

@@GyanOnTube can you please make formula for it ....
please

[@GyanOnTube]

Sure will do that

[@luckykashyap6736]

Only video to find this

[@GyanOnTube]

Sorry

[@akashthakur5615]

Excellent

[@GyanOnTube]

Thank you so much Akash Thaku ji..keep sharing keep learning

[@susantadas2209]

Nice

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@azeemquryshi1179]

Last name ki jagah change karna hai bisht Sonu Kumar ko Sonu Kumar bisht krna hoto kaise kare

[@azeemquryshi1179]

Same hi column me hona chahiye

[@GyanOnTube]

Use wild card..

[@ashfaqaayat6465]

Mere note mai 500 naam hai aur mujhe ek naam kab se kab 20for example

[@GyanOnTube]

Please elaborate

[@lokeshpn4896]

My name is lokesh p n what is first name middle name and last name

[@GyanOnTube]

This function will work accordingly to spaces

[@Updatemakingvideo]

Mera work Q nhi kr rha Sir?

[@GyanOnTube]

Kya error aa raha hai aapka

[@kishorpanara4191]

Sir power query ka tutorial first to end start karo

[@GyanOnTube]

Sure Kishor ji...bahut jald leke aaunga uske uper videos

[@dilkushsharma2772]

Value error aa Raha hai but showing the result

[@GyanOnTube]

Are you using office 365

[@dilkushsharma2772]

@@GyanOnTube yes

[@shivamkumarrai1985]

HELLO SIR
MUJHE RAM KA. .. R
GOPAL KE ....G
Lal ka ....L
Chahiye
Please sir

[@GyanOnTube]

Left se one le lo.. simple

[@makbulansari2255]

BEGAM,BIBI,KHATUN kahape ayega

[@GyanOnTube]

Means

[@nkkachave2203]

Bhai single name nhi aa rha

[@GyanOnTube]

Single name sirf first column mein hi show karega

[@ihsankhan246]

Bhai mera naam ihsanullah hai Mera is name mai last name kya hoga jawab zaroor dijiye

[@GyanOnTube]

Dekhiye..agar aap aapna name ihsanullah likhte ho to usme last name kuch nhi hoga..agar aap aapna name ihsan khan likhte hai yo last name khan hoga...

[@rizvanrizzy9534]

Nhe bhi bhot lanba procedure hai.🤯🤯🤯🤯

[@GyanOnTube]

Let me prepare a short video for you as well

[@gopalsersiya5070]

MIDDLE NAME NIKLANA BOHOT MUSHKIL FORMULA HAI

[@GyanOnTube]

But one time activity ke liye theek hai

[@techpoint6396]

bhai koi aur trick hai jisse find kr skte hai

[@GyanOnTube]

Hanji power query

[@mgskmis]

when name only have 1st name. then it's not working. Like: Ram.

[@GyanOnTube]

It will fetch only first name

[@paramjeet975singh3]

Nicee sir vba ka karaiye plzz sirrrrrr

[@GyanOnTube]

Sure Paramjeet ji..will bring video very soon on vba

[@paramjeet975singh3]

@@GyanOnTube thanx sir basic se advance karana sir

[@kajalsharma-nq3gu]

Ye tarika na bhot long hai or koi bhi ise aasani se yaad nahi rakh sakta agar vo kuch din practice kare ga to yaad rahe ga or jese hi or chorta hai vo bhul jaye ga is formule ko or khai bhi kisi ke pass itna time hota jo itna lamba formula use kare ga iske bhot sare tarke hai short tarike se bhi answer aa jaye ga to short karao na ki long

[@GyanOnTube]

Hamesh new cheeze zaroor seekhni cahiye

[@abd360laxman2]

Shilpa l isme first middle last name bolo sir

[@GyanOnTube]

Means

[@abhishekkore987]

ise simple bolte he kya ...... khuch bhi yr hat

[@GyanOnTube]

Kosis karoge to sab simple hai 😊

[@s.r.8235]

Need help

[@GyanOnTube]

Yes please

[@advocate.lalitsharma.4805]

sir aapke sabhi video bahut good hain aapse nivedan hain ki aap yeh video banaye is video ki pure world me jarurat hain video ki hyperlink aapko bhej rahu hu ( lalit sharma mob 9826537455)
ua-cam.com/video/u1Uted_LzXE/v-deo.html
ua-cam.com/video/LmlC95xOx5g/v-deo.html

[@GyanOnTube]

Ok lalit ji..you want to compare data...i got you point.let me work on it..

[@pathanarifkhan8304]

Mid se nikal leta

[@GyanOnTube]

Happy learning

[@ashutoshgaurav7765]

You are creating way to much formula confusion

[@GyanOnTube]

This is only way without vba...ese no other formula will work..you can give a try

[@RaviKumar-yi3iu]

Bhaut lendi hai sir

[@GyanOnTube]

Please try once you will learn it

[@dineshbhati8941]

Hlo sir I have an urgent work can I contact you ...I want find unique values separated by comma for example: A1: 13,65,34,28, And B1: 67,34,28,77 now result (C1) is 13,65,67,77 bcz 34, 28 is comman so we can't add ..ita my question

[@GyanOnTube]

Hi Dinesh ji..unable to understand your question..can you please elaborate

[@dineshbhati8941]

Cell A1= 25,7,3,61
Cell B1= 7,3
Now I want to delete comman value jese value(7,3) dono cells me he so I want final result in C1=25,61 kyu ki ye value B1 me nhi he
Cell C1= 25,61 aana cheye

[@GyanOnTube]

Nice question..we need to prepare formula for this...let me check and will get back to you

[@dineshbhati8941]

I hope ap jldi rply kro thnx

[@dineshbhati8941]

Hlo sir kuch solution mila ky

[@rkorko4478]

Thanks

[@GyanOnTube]

Thank you so much