Скачать или смотреть 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/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