How to Extract PIN Codes in Excel from Messy Address Data – Without Flash Fill!

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/1EW3QGFVq86cLMjZo2eIn8tYa3fxxdiLK/view?usp=sharing 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 : https://www.youtube.com/@Skill-Course My Other Channels: Real Tutorial: ✅ https://www.youtube.com/@realtutorial550 Complete Technology:✅ https://www.youtube.com/@CompleteTechnology Learn more shorts:✅ https://www.youtube.com/@LearnMoreShorts Satish Tech (Marathi):✅ https://www.youtube.com/@Satish_Tech Tally Tutorial:✅ https://www.youtube.com/@TallyTutorial Excel Tutorial:✅ https://www.youtube.com/@Excel_Tutorial Learn More:✅ https://www.youtube.com/@Learn_More_Pro Curiosity: ✅ https://www.youtube.com/@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