View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Text Search in an Array

The SEARCH and FIND functions in Excel allow me to find text strings within a
single cell. Is there a function that would allow me to search for a text
fragment in an array of cells? The text fragment may be embedded in a longer
string (i.e., it would likely not be an exact match), so I dont think that
the LOOKUP functions could be employed.
--
Jay