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 KZitem 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
Негізгі бет "Unbelievable Excel Trick: Flash Fill Can't Handle This Challenge!"
Пікірлер: 118