Fast way to search many cells by column for text strings

M

Mikee

Am looking for quick way to search for and list, a specified, given text
string in all cells in a column, e.g. look for text string " E/G "
 
M

Max

Assume the target col is col A, data from row2

Put in B2: =ISNUMBER(FIND("E/G",A2))
Put in C2: =ISNUMBER(SEARCH("E/G",A2))

(FIND is case sensitive, SEARCH is not case sensitive)

Select B2:C2 and fill down

Put a label into B1:C1, then do an autofilter in B1 (or in C1) to filter out
the rows with: TRUE, depending on whether search is to be case sensitive or
not.
 
D

Dave Peterson

I'd apply data|Autofilter to that column.

Then do a custom filter of: Contains " e/g "
 
Top