How to use Regular Expression for data validation in Excel 2010

I use Regular Expressions (or RegEx) for data validation in Excel 2010. It is extremely fast, very flexible and powerful in the sense that its logic will only ALLOW the exact data you want to be processed - everything else will be validated as invalid.

Using Regular Expressions negate the use of multiple If, Then, Else or Case statements. This article will cover validating different types of data using a simple Regular Expression Subroutine. I will also provide an IsValid Regular Expression Function and some common Regular Expression patterns for you to try out.