Some tips on using Regex from Excel VBA

One of the techniques that is very useful to have in your tookbox is using Regular Expressions. The Microsoft implementation of Regular Expressions is called Regex.

As a sidenote the .NET Namespace you need to include in your  using statements in your .NET projects is the following:

 

Regex is essentially a way to manipulate strings and in particular to perform one of the following type of operation:

  • Parse
  • Validate

Some examples of using Regex from Excel are the following:

Authored by: admin

Leave a Reply

Your email address will not be published. Required fields are marked *