Your search specification is for "aaaa" followed by any or no
character(s) followed by "2222". If "2222" is not preceded by
"aaaa" (or "AAAA", as SEARCH isn't case-sensitive) anywhere in the
string, the formula will return False.

Mark Lincoln

On Sep 12, 10:38 am, 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- Hide quoted text -

- Show quoted text -