Wow Kya Excel Tutoring Hai 😮 Interview Trick Flash Fill

Wow Kya Excel Tutoring Hai 😮 Interview Trick Flash Fill
Doston is video me maine bataya hai ki kaise aap Microsoft Excel me shortcut key ka use kar ke first name aur last name ko alag kar sakte hain ya kaise first name aur last name ko aik cell me joint kar sakte hain.
Friends, in this video I have told how you can separate first name and last name using shortcut keys or how to join first name and last name in one cell in Microsoft Excel.
If you like the video, then Please Don't Forget To Do...𝗟𝗜𝗞𝗘 , 𝗦𝗛𝗔𝗥𝗘 , 𝗖𝗢𝗠𝗠𝗘𝗡𝗧 , 𝗦𝗨𝗕𝗦𝗖𝗥𝗜𝗕𝗘.
It's motivates me to create more contents.
#excel
#short
#tipsandtricks
#youtubeshorts
#nerdysaim

[@NerdySaim]

Doston agar aap MICROSOFT OFFICE 2024 latest VERSION ko DOWNLOAD aur INSTALL karna chahte hain to Channel Name ke niche Pinned Video ko dekhen Ya Channel pe Jayen Video mil jayegi.

[@diwakarpandey1846]

Sir ye trick mere excel m nhi ho raha hai😢

[@NerdySaim]

Flash Fill sirf Excel 2013 aur uske upar ke version me milta hai.

[@mohammadrehanhussain5142]

Wow...👏 your excel trick is really awesome 🔥🔥🔥💯

[@NerdySaim]

Thanks 😎👍🏻

[@kadubhaimakvana6959]

wahh sir..
super trick..🎉

[@umeshtambe4265]

I am really very very very grateful to you. Please keep doing this task 😊❤

[@NerdySaim]

Thank you 👍🏻🙂

[@RakeshSingh-dy9gd]

I really liked this trick. Can you share the formula also, please?

[@Enmamarmedia]

Dear I have some video,please initiate me by subscribing and commenting.
Thankyou for your response.

[@TechTrends2864]

There is no formula this is only work in latest version

[@RishabhShukla-zr3ex]

Which version do you have in build this feature

[@NerdySaim]

Flash Fill is only available in Excel 2013 and later.

[@student-excel]

For full name;
=CONCATENATE(A1,"space",B1)
First name;
Text cell option available in DATA tab

[@poonamjha94]

Wow very useful trick

[@VipinKumar-oq8um]

Use concatenation formula to add first and last name simultaneously ...
CONCATENATE("FirstName"," ","LastName")
Note:- Use space in double quotes in the formula so that it can give space between first and last name

[@NIMITchawla2470]

Amazing trick

[@gamingwithshobby9803]

Is there any way I can get a new workbook by clicking on any text in other workbook

[@hareramprasad7791]

Very interesting and motivating

[@NerdySaim]

Glad you think so!

[@sam_Din]

Very informative

[@gunjasahani9270]

Very good 👍

[@NerdySaim]

Thank You 🙂

[@Hdearning2023]

Khtarnaak trick bikul BHai ek dm

[@shitalshinde6756]

Very helpful....thank you so much

[@NerdySaim]

Your welcome 👩🙂

[@akhileshmaurya846]

Very helpful

[@rocksndthebeauty9233]

Bht sahi lga Maine subscribe kr liya .😊

[@NerdySaim]

Thank you 🙂

[@deepaksharma-bl9ld]

Very nyce trick

[@alexasaifi6459]

Such an informative video thanks a lot sir. ❤❤

[@NerdySaim]

Welcome 🙂

[@vivekmourya07]

Its very simple👍thanks sir

[@NerdySaim]

Welcome 🙂

[@INSPIREDINDIAN98]

This is called Flash Fill 😊

[@kurbanali-x1q]

great sir ji

[@saritakumarichaudhary7109]

Very nice information sir

[@pradeepkumar9464]

Great 👏

[@NerdySaim]

Thanks 👍🏻

[@satishkotalkar3590]

Nice video

[@sharukzada963]

Isi tarah tips lateh rahena bhai

[@ramasharma3662]

Wow, it works

[@Enmamarmedia]

Dear I have some video,please initiate me by subscribing and commenting.
Thankyou for your response.

[@TheAyushShrivastava]

Thanks bro❤

[@NerdySaim]

Welcome 😊

[@anitagusain7263]

Woww sir very nice aise or videos banaiye ❤

[@NerdySaim]

Thank You Anita, Aap channel visit karo aisi bahut sari videos apka wait kar rahi 😎

[@shrihanumanbhakt]

Power of flash fill (ctrl+E)

[@monstorgamer9635]

thanks for option name ❤️

[@bidyakpani3559]

Wow very nice bhai

[@user-mz7kb1pr4h]

Very nice

[@taxminus]

Thanks for sharing ❤

[@SubrataSaha200]

E to nehi ho rahi he

[@aman-ullah-erfan]

Same😢

[@saadmd069]

Good trick

[@sritiyadav752]

Nice trick ❤

[@gouranshprabhat4210]

Nice information 👍 Sir . Keep updating us in future also. Please suggest that how can we use this technique in Windows 7🙏?

[@NerdySaim]

Thank you 🙂, Operating system se iska koi connection nahi hai aapko apne computer me ms office 2013 ya usse upar ke ms office version ko install karna hoga jisse aap Flash Fill ko use kar payenge.

[@Amanraj_1598]

Bhaut sahi vedio

[@NerdySaim]

Thanks 🙂

[@chandraprakashsoni8163]

Nahi hua

[@NerdySaim]

Flash Fill sirf Excel 2013 aur uske upar ke version me milta hai.

[@ranadk1]

Nice Work 👍🏻

[@Mastloki]

زبردست

[@kalpanagamango1362]

Thank q sir.

[@NerdySaim]

Welcome 🙂

[@Mdevpal.Official.73]

❤❤Nice information sir❤❤

[@nandansingh9943]

Great Sir 👍

[@mamtasingh8591]

So nice video

[@Rupesh-STAR]

wooow so easy

[@gaurav8194]

Thanks a lot

[@Djmpking-yx5cx]

Super

[@deepanshukumawat0598]

It's good 😊

[@sanjeevarora3945]

Good one.
God bless you

[@NerdySaim]

Thank you so much 😇

[@AkhileshPatel-rj6uk]

gajab trick

[@simmokumari6478]

thank you so much sir 😊

[@NerdySaim]

Welcome 🙂

[@Enmamarmedia]

Dear I have some video,please initiate me by subscribing and commenting.
Thankyou for your response.

[@RajKushwaha-ul4qe]

So nice😊

[@mistyroy-yr8qq]

Wow very nice

[@NerdySaim]

Thank You 🙂

[@mistyroy-yr8qq]

@@NerdySaim most welcome ❤️ &go ahead ❤️

[@jitendrakumarsingh309]

Nice 👍

[@pradeep554]

बहुत अच्छी जानकारी है लेकिन ये सिर्फ दो शब्दो के नाम पर ही सही काम करती है उससे ज्यादा पर नही। यदि text to column use Kiya Jaye to acchha result milega

[@CSPLMUMBAI]

Thanks

[@NerdySaim]

Welcome

[@noorjahansumi5452]

Thank you so much

[@NerdySaim]

You're most welcome.

[@saminaghayas537]

Good sir❤

[@shaunakofficial2590]

Bahut achha tric

[@NerdySaim]

Thank You 😇

[@dreammerchant-to9kx]

Great 👍

[@ZahidaAysha1126Arzoo]

Brother, please tell which camera you used in this video?plz

[@NerdySaim]

This is screen recording not camera.

[@Onelifebaby777]

❤❤❤❤❤super sir

[@Deepakyadav-gp4ty]

But we can also use left or right formula, if interviewer asked only formula based solution required.

[@RakeshSingh-dy9gd]

Can you share the formula, please?

[@snehasisroutray1900]

​@@RakeshSingh-dy9gd =LEFT(FULL NAME,FIND(" ",FULL NAME)) For first name
=RIGHT(LEN(FULL NAME CELL)-FIND(" ",FULL NAME CELL))

[@trailblazer830]

Yes we can also use first, mid, last function in this particular scenario.

[@excelmaster1328]

​@@snehasisroutray1900how can extract this name :-RAMESHkumarMUKESH
Through formula only ?

[@student-excel]

For full name;
=CONCATENATE(A1,"space",B1)
First name;
Text cell option available in DATA tab

[@SujeetKumar-qy6iu]

Wow

[@madanbhuktabhukta7248]

Thank you so much sir

[@rahul_____yadav1296]

Etna sort tarika😮

[@arvindpandey8793]

Nice,
Column text extending bhi toh kar sakte hai

[@Rrohits30]

👍good

[@ravindranegi7033]

Love you sir.❤

[@MadhusudanSharma-de7km]

We Do Work try Again

[@k.g.f8427]

Tenkiu

[@faizangotnawi4554]

Superb

[@khanzzreact6741]

Wow....super bro... awesome 👌

[@skrehanqureshi5827]

tumne to formula lagane ka tension hi khatam krdiya, only ctrl+E 👏👏👏👏👏👏👏👏👏

[@NerdySaim]

Yes, flash fill⭐excel ka best feature hai. 👍😎

[@MrDTT-js1cb]

Mera computer main nahi horaha hain​@@NerdySaim

[@NerdySaim]

@@MrDTT-js1cb Flash fill sirf Excel 2013 aur uske upar ke Version milta hai. MS Office 2024 ko free me install karne ke liye mere channel pe jao video mil jayegi.

[@Black-f2r]

🔥🔥🔥🔥TRICK

[@swatipatil-gt5mz]

Mast triks tq sir

[@NerdySaim]

Welcome 🙂

[@hareramprasad7791]

❤❤❤

[@sakshijain8556]

U can use formula select name then &" ",& then sir name then enter

[@syedarmaan5394]

Wah sir .. kya baat hai.. ye humse kyu nahe ho raha .😮😮😮

[@NerdySaim]

Flash fill sirf Excel 2013 or uske upar ke version me milta hai.

[@radheyvaishnav7592]

Ok

[@dreamingeye3656]

Great

[@NerdySaim]

Thanks 🙂

[@chandrikaji696]

Thank you sir

[@NerdySaim]

Welcome 🙂

[@DIBASH]

Nehi huwa brother Mera Excel me

[@memerworld403]

Sir Concatenate bhi to lga sakte thea frr se joint karne ke lyea

[@NerdySaim]

Yes

[@Anil-Thapa]

nice
thank you

[@envazhlithalapathyvazhli9197]

If you say this is an interview question so learn the trick, tell after joining how they show the excel skill.
So tell me this is just one of excel learning and not as a interview question

[@2brothers0]

🤗

[@Sanjana_B7]

Bhaiya jaise excel file me multiple sheets hai tho wo sab sheets ek hi sheet me kaise copy karna hoga...thode sheets me formula hai protection hai

[@biswajitsingha4423]

Suoer

[@tufangamer7910]

Best

[@MohammadJaid-ob1zf]

Ye sahi tha guru 👌👌

[@abdulhamidkhan7133]

Awesome

[@SouravKumar-dd1vv]

Use text to column function using delimited And space

[@celebstoday3560]

#youtubeshorts #programmingshorts #programmers #batch
ua-cam.com/users/shortsy2A5m8rCs2I?feature=share

[@pramodkr2512]

Nice and tnx

[@eluraisenmp3604]

Nice

[@NerdySaim]

Thank You 👍

[@user-wb2el2jq3l]

Very good 🎉❤😂 ram 🎉😊

[@devanshsharma9292]

Thanx

[@himanshugupta517]

Thankyou sir

[@SaadFarooq286]

Zindaabad😊

[@s.k.actecnitionnewclasses6018]

good bro

[@adityasahu8105]

thanks 😊

[@BIKIEXPRESS12345]

tq

[@sayanbhattacharjee6867]

Why not use text to coloumn?