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:
Some examples of using Regex from Excel are the following: