TM,

I think this is just a difference in philosophy. Your formula

=ISNUMBER(SEARCH("aaaa*2222",A1))

is so far the most elegant that could solve the OP's problem precisely
as the OP presented it. The other formulas are longer, but more
flexible, and may be useful to other people (or to the OP himself, if he
didn't completely specify the range of cases).

Just my 2¢.

- David Hilberg

Teethless mama wrote:
Give me a break.

It still work even 2222 appears before the aaaa


"Dave Peterson" wrote:

Until the 2222 appears before the aaaa.



Teethless mama wrote:
My is much neater than Dave.

"Roger Govier" wrote:

Much neater, Dave!!!

--
Regards
Roger Govier



"Dave Peterson" wrote in message
...
Or just:
=ISNUMBER(FIND("aaaa",A2)*FIND("2222",A2))

To the OP:
=Find() is case sensitive
=Search() is not case sensitive

Roger Govier wrote:
Hi Tim

One way
=IF(ISNUMBER(FIND("aaaa",A2))*ISNUMBER(FIND("2222" ,A2)),TRUE,FALSE)
copy down

--
Regards
Roger Govier

"TimD" wrote in message
...
My data sample:

aaaa-*5#8-2222.zip
bbbb-0987-2345.dat
bbbb-*458-2222.xls

I want to return the cell that contains aaaa and 2222.


--

Dave Peterson


--

Dave Peterson