Fast way to search many cells by column for text strings

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 "

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.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Mikee" <Mikee@discussions.microsoft.com> wrote in message
news:55723363-1339-48B0-B984-513F46FEB909@microsoft.com...
> 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 "

I'd apply data|Autofilter to that column.

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



Mikee wrote:
>
> 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 "

--

Dave Peterson