Are you struggling to extract 6-digit PIN codes from messy address data in Excel? Flash Fill, Text to Columns, LEFT, and RIGHT functions won’t work when the PIN appears at random positions — start, middle, or end. 😓
In this video, I’ll show you two powerful methods to solve this real-world Excel challenge:
✅ A detailed Excel formula using MID, SEQUENCE, MATCH, and TEXTJOIN
✅ A custom Excel function built with the help of ChatGPT
Both techniques are explained step-by-step so you can understand the logic behind them and apply it to your own data analysis tasks.
💡 This challenge came directly from one of my students during a live Data Analysis Masterclass, and another student working in an MNC cracked it brilliantly! Now it's your turn to learn this game-changing Excel trick.
🔍 What You’ll Learn:
Why Flash Fill fails in complex data cases
How to build dynamic formulas for real-life Excel problems
How to use AI (ChatGPT) to build custom Excel functions
How to extract exactly what you need from messy text data
Practice File : https://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
👍 Like, Share & Comment
Let me know in the comments: Did you understand the formula?
If yes, tell me how you plan to use it! If not, I’ll be happy to help.
📢 Don’t forget to subscribe for more Excel & data analysis tips every week.
#ExcelTips #DataAnalysis #ExcelFormula #FlashFill #ChatGPT #ExcelHack #PinCodeExtractor
Get Free Notification for Upcoming Videos = https://forms.gle/9G2xL2c5XrA14HvbA
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Course Website :https://bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : https://skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: https://learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: https://bit.ly/3CvGlBT
Instagram Page Link: https://bit.ly/3f9R37u
Telegram channel: https://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 YouTube Gears :
Best Mic for Recording (Condensor Mic): https://amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): https://amzn.to/3pQgyvD
My DSLR Camera Canon 200D: https://amzn.to/39ciw3E
My Laptop (Video Editing): https://amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : https://amzn.to/3l0pniw
Antivirus: https://amzn.to/3l3TIgi
Screen Recording Software: https://bit.ly/2J39n2j
Video Editing Software: https://bit.ly/3nOPlri
Green screen with Stand: https://amzn.to/2KAl1Cu
Информация по комментариям в разработке