Do long formulas in Excel scare you?
👉 Example:
IFERROR(TEXTBEFORE(IF(LEFT(IFERROR(TEXTBEFORE(IFERROR(TEXTAFTER(B6,"_"),""),"_"),""),1)="E",IFERROR(TEXTBEFORE(IFERROR(TEXTAFTER(B6,"_"),""),"_"),""),""),"/"),IF(LEFT(IFERROR(TEXTBEFORE(IFERROR(TEXTAFTER(B6,"_"),""),"_"),""),1)="E",IFERROR(TEXTBEFORE(IFERROR(TEXTAFTER(B6,"_"),""),"_"),""),""))
Most people panic when they see something this complex.
But in this video, I’ll show you how to:
✅ Break the formula into small, easy-to-understand parts
✅ Use functions like IFERROR, TEXTBEFORE, TEXTAFTER, LEFT step by step
✅ Combine them to build a powerful formula for real-life scenarios
💡 That’s how you transform complexity into simplicity in Excel!
📌 Perfect for professionals, students, and anyone who wants to master advanced Excel tricks.
👉 Subscribe for more tips: Excel With Vidu
#excel #excelwithvidu #exceltips #datacleaning #problemsolving
To increase the efficiency of your company's employees 🏢, simplify their work life ✨, and boost profitability 💰, contact us now 📞 to get our highly sought-after Corporate Training Program, which is currently the most demanded in the corporate sector of Sri Lanka. 🇱🇰
📱 For inquiries:
Chanuth: 071 121 96 75
Chathuranga: 076 421 96 75
If you're interested in creative video content or event coverage, call us today!
📞 Thilina: 071 877 0923
Join our WhatsApp Announcement Group: Join Here
Contact us on WhatsApp: Send a Message
Follow us on Social Media:
Instagram: @excel_with_vidu
Website: excelwithvidu.com
Facebook: Excel with Vidu Facebook Page
TikTok: Excel Vidu TikTok
LinkedIn: Vidura Chathuranga LinkedIn
Информация по комментариям в разработке