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 <atyahoo<dotcom
----
"Mikee" wrote in message
...
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