VBA – RegEx Used to Take the Valuable Data Out

Writing for RegEx in VBA is sometimes a good idea and sometimes a bad idea. Anyway, if you need to write one, you better be careful.

These are the RegEx articles in VBA in VitoshAcademy so far:

  • https://www.vitoshacademy.com/vba-regex-in-excel-part-2/
  • https://www.vitoshacademy.com/vba-regex-in-excel/

So, imagine that you have some interesting strings that need to be processed. The first thing to do is to see whether it could be processed and the second thing is to return the processed string. Something like these two similar functions would work out nicely:

Cheers! 🙂

Tagged with: , ,