Regex in Excel - Mastery through Examples
0Excel has wildcards, which allow for intelligent text extraction but still lack power. Imagine, you could supercharge that! Yes, you can use REGEX (Regular Expressions). In this session, Victor will walk you through examples of varying complexity to showcase the power of REGEX in solving Excel problems. The examples would range from simple REGEX formulas to XLOOKUP with REGEX and data validation. Fasten your seat belts and enjoy the flight. Victor Momoh is a 2x Microsoft Excel MVP from Nigeria. A Petroleum Engineer by day and an Excel Enthusiast at night. Victor is passionate about teaching and sharing knowledge and does that through various mediums, including his YouTube channel, “ExcelMoments”. His love for dynamic array formulas is seen in most of his content to the admiration of his audience.
[eventID:25015]