Thread: Muliple lookup in one cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Muliple lookup in one cell
=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.


Reply With QuoteReply With Quote