"Unbelievable Excel Trick: Flash Fill Can't Handle This Challenge!"

In this video, I will us a unique and effective method to extract 6-digit pin codes from an address column in Excel using a tricky formula. Forget about Flash Fill! This trick will streamline your data processing tasks and enhance your Excel skills. because I have used, Len formula, Mid formula, Match formula and sequence formula of excel to get this.
🚀 What You'll Learn:
How to identify and extract 6-digit pin codes from a complex address column.
Step-by-step guide to creating a powerful Excel formula for this specific task.
Tips and tricks to improve your data management efficiency.
#Excel #ExcelTips #DataProcessing #ExcelFormulas #FlashFill #exceltutorial
👉 Challenge for you!!!, Ye video me jo practice file hai mai de raha hun usme address me pincode hai use alag karna hai kudse try kijiye nahi solution mila to yahi video dekh lijiyega, PRACTICE FILE :
drive.google.com/file/d/1EW3Q...
Excel 2016 aur Older version hai to unke liye ye formula hai : =MID(A2,FIND("@@@@@@",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,1,"@"),2,"@"),3,"@"),4,"@"),5,"@"),6,"@"),7,"@"),8,"@"),9,"@"),0,"@")),6)*1
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/learnmoreindia
------------------------------------------------------------------------------------------------------------------------------
For Short tips : / @skill-course
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more_pro
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My UA-cam Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu

[@Learn_More_Pro]

👉 Challenge for you!!!, Ye video me jo practice file hai mai de raha hun usme address me pincode hai use alag karna hai kudse try kijiye nahi solution mila to yahi video dekh lijiyega, PRACTICE FILE :
drive.google.com/file/d/1EW3QGFVq86cLMjZo2eIn8tYa3fxxdiLK/view?usp=sharing
Solution mila to comment kijiyega aur Excel 2016 aur Older version hai to unke liye ye formula hai : =MID(A2,FIND("@@@@@@",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,1,"@"),2,"@"),3,"@"),4,"@"),5,"@"),6,"@"),7,"@"),8,"@"),9,"@"),0,"@")),6)*1

[@friendly8342]

Sir me zero se Microsoft Excel to advance level ka Excel ek hi course me Sikhna h so which course to buy

[@ambikamaurya2601]

Hello sir, I just came here after getting my Excel beginner to advance course Certificate 🎉😊 Thankyou so much for your guidance . Best teacher ever!! ✨️

[@romilbari9673]

Excel booster 💥

[@rahulvishwakarma2119]

=Aiextract(data,"pincode")

[@asmrindia]

Very Nice Sir
Thanks

[@balwantswami704]

Jai ho Gurudev, Very well explained

[@darshitchavda8264]

What a logic sirjee.... awesome.... & Excel booster

[@hellodaraihiya3670]

Thanks sir 🎉❤

[@muhammadumairakhtar5177]

Bahut khoob

[@Harshsanjana]

Explanation is good

[@vikramraj1464]

सर कंपनी में कौन-कौन सा काम आता है और कैसे होता है, यह सबके बारे में वीडियो बना दीजिए सर।

[@thepintuvlogs]

Thanks sir ❤

[@TechnoEveryday]

Jabardast🎉🎉🎉🎉

[@vikramraj1464]

Thanks sir ji

[@sushilprajapati200]

this is very best

[@khanarif2562]

One of the best teacher of computer specially for Ms office love ❤ from Pakistan

[@nil_auto]

Good 👍

[@sachinkale4544]

intresting

[@arunkumarsinghark3024]

🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
सीखते रहो, सिखाते रहो l
हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l

[@smmexp9]

of course you are excel booster🚀

[@bhokaltoligaming3123]

Excel Booster 💪

[@Adityasshenoy-rw4ox]

I want to learn about Excel booster tool..sir ❤

[@user-xs5fb6nx2m]

thank you sir satish dhawala ,,,,,,,,, ( irfan butt ) love you from pakistan ,,,,,,,,,,,,,

[@irfanshaikh5577]

Excel Booster ✈️✈️

[@susovonnath2654]

We can use AGGREGATE function instead of MATCH. =AGGREGATE(14,6,MID(Table1[@Address],SEQUENCE(LEN(Table1[@Address])),6)*1,1)

[@toxic9689]

Excel booster

[@adepukrishna]

Xl booster
🎉🎉🎉🎉

[@tallyeducationplatform1435]

Excel booster Video required

[@rakeshanb2464]

@learnmorepro sir I can't able to find the extract formula to copy please help me out sir

[@emmi.x]

Hello sir
Please give me some solution, in my Excel sequence functions not available. What should I do, to use this function in my excel

[@acieducation6401]

Sir tarike se kya kya hum khuch bhi alag kar sakte hai

[@SmileCartoonZone]

XL booster in want 😍

[@arunkumarsinghark3024]

Excel booster chahiye

[@soumenmalik8888]

Xl booster review

[@asifalipinjara3840]

Python par video banaye

[@jhonnydeppfan4370]

XL boost

[@vikramraj1464]

Sir company mein कौन-कौन sa kam aata hai aur kaise hota hai yah sab ke bare mein video banaa dijiye sar.

[@altafamirali4946]

XL Boost

[@tuniqueonlineshopofficial]

XL booster

[@The_Stories_1M]

Excel Booster

[@EktaAggarwal-tj9sp]

Xl-booster

[@maheshkaushik1722]

Kuch pincode number agar 99999 se kam hue toh and kuch jyda formula mein kya change karenge

[@nirupammishra7434]

xl booster

[@EktaAggarwal-tj9sp]

El-booster

[@harishsharma7721]

XL Booster

[@rohitindian9502]

Xl booster

[@CRICKOOT324]

Sir mene abhi abhi aapka 99 Rs. Wala course purchase kiya hai ... But muje kuch doubts clear karne hai ... Muje thodi si problem aa rahi hai course me and helpline number lag nai raha ... Kindly reply me 😢

[@friendly8342]

Sir i want to learn POWER BI zero to advance level but you didn't launch power bi course tell me how can I learn POWER BI by you

[@lokeshdasariya5874]

sir, what if pincode is 5 digit??

[@emmi.x]

Where is the code for extractpincode function?

[@vssgaming7563]

Excel tools

[@vssgaming7563]

Excel postur

[@salimullah7117]

Convert date to Urdu word in excel....

[@vssgaming7563]

Excel Postery

[@mdsarfarazalam8432]

Extract pincode de dijiye

[@ahilkhan77]

Excel ka naya course lao sir

[@mdsarfarazalam8432]

Sir extract pincode file dijiye

[@rohitkusbhage4394]

Too much complications

[@nabinmandal631]

Sequence is not working in my excel

[@vssgaming7563]

Excel postor

[@mdsarfarazalam8432]

Extract pincode work nahi kar raha hai name error aa raha hai

[@gopalparmanik6708]

Mujhe client address me bhi pincode deta hai aur alag se row me bhi deta hai, mujhe address se pincode remove karna hai with text "pin code" "pincode"

[@pradeepkumarahirwar6619]

समझ मे नही आया लेकिन कोशिश करते है समझने की

[@ravitalhar124]

Excelbooster

[@sachchidanand5952]

Xl Booster

[@YoutubeThumbnailDesigner]

My Thumbnails

[@Villager_art]

Yi maira drawing ka channel hain

[@mjmovies5364]

xl bost

[@mdsarfarazalam8432]

Woh aapne Diya he nahi aapne to bataye de dunga send kar dijiye please..

[@abhinavvlog7451]

Excel boster

[@shibuadak7419]

excleboostr

[@rahulsinghrautela2919]

Xlbooster

[@shamabano8024]

Sir hame aap ke institute per ake course karna please contact num

[@prafulsheraji4434]

Hello sir, very nice explained and superb formula designed.
I also have one query
I am working on inventory report with Adani Group.
In YTD Report there are so many calculations and confusions.
I can share datas and logics on email address.
Please share your email address

[@khanawais5154]

Excel booster

[@rajeshmahabal4397]

XL booster

[@ANSARIAFZAAL]

Excel Booster

[@rakeshanb2464]

xl booster

[@SparkVision1]

XL Booster

[@manishkumaragrawal1278]

Xl booster

[@nirmalbehura9039]

Excel booster

[@kishorpanara4191]

Excel booster

[@omtiwari6442]

Excel booster

[@manojchavane3650]

Excel booster

[@maheshkaushik1722]

Excel booster

[@Rameshkumar-rf6gc]

Excel booster

[@prasadgaonkar5815]

Excel booster

[@ALLINONE-fz5bb]

Excel booster

[@earningablebybiraj3243]

Excel booster

[@pinkitiwari7423]

Excel booster

[@monishkhan3732]

Excel booster

[@durgeshmourya3226]

Excel booster

[@AbhishekKhare-ty6yb]

Excel booster

[@suhashjar1211]

Excel booster

[@ryjn6529]

Excel booster

[@ShaunakShah-ln4yn]

Excel booster

[@tunabehara9884]

XL booster

[@fakhirafatima]

XL booster

[@abarkat6196]

Excel Booster

[@sukeshkumar9047]

Excel Booster