Search for text within text
Hi, I have the following problem with data that looks like the below:
A1. "Non Rec 2004"
A2. "Non Recurring 2005"
A3. "Non Rec 1 12 2006"
A4. "non Rec 2006"
A5. "Non Recurring 2006"
A6. "Recurring 2005"
What I am trying to do is to identify in this list what are the non 2006
items with text data that is not consistently formated. The aim is to obtain
a list of the items which are related to 2006, 2005, 2004 etc. also.
Any suggestions?
Thanks Speedy
|