Hello Ibrahim,

I think this will do the trick. The formula can easely be added to for
additional search criteria and is flexible enough.

Thanks for your input.

Regards,

Speedy

"Ibrahim" wrote:

Hi Speedy,

AND(ISNUMBER(SEARCH("Non",A1)),ISNUMBER(SEARCH("06 ",A1)),ISNUMBER(SEARCH("*rec*",A1)))
Is this what you are looking for. Let me know.

-Ibrahim

"Speedy" wrote:

Addendum: The dates can also be written as YYYY or YY i.e not consistent
with number of digits also.

"Speedy" wrote:

Dear Ibrahim,

Thanks for your reply. Your suggestion seems to be the closest to what I
need. I will experiment with it.

What would you suggest to handle the fact that for e.g. Non Recurring or the
dates can be found in many different style (non Rec, Non Rec, Non Recurring,
dd/mm/yy, MM/dd/yy, etc....)?

Thanks for your help.
Speedy.

"Ibrahim" wrote:

Try this:

=AND(ISNUMBER(SEARCH("Non",A1)),ISNUMBER(SEARCH("2 006",A1)))
and drag through the column. Would show TRUE in case the text contains both
NON and 2006.

-Ibrahim


"Speedy" wrote:

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