This does not seem to return a cell, it returns a calculated value.


"Teethless mama" wrote:

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


"TimD" wrote:

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.