Use Regex (Regular Expressions Library) in VBA for Data Manipulation in Excel
This video demonstrates the power of RegEx when added with VBA to the Excel. Regular Expressions gives us super fast results when matching a text string on basis of a certain criteria (AKA Regex Pattern). It help us to avoid use of recursive functions / loops and many other decisive function.
Watch the power of RegEx in the video and share your comments.
