View Full Version : String lookup to get month

04-26-2012, 06:15 AM
Hi I am looking a VB code which can help me look up in a string and give me month in a cell. My problem is the data is set as it can have multiple variations to it and can have 2 or more answer to it. The months can be either be Mar, .03., .3, March which again not consistent.

I have attached an example for reference hope someone can help me with this.