search a column for multiple words

[jbrennan]

I'm completely new to excel, so I apologize if this is a silly question, but I'm really stuck. I have to search for a list of street names in an excel document every week, and I've been doing it manually and its killing me. Basically there are 200 rows of data and I need to be able to find any row that contains a list of 50 or so street names and remove them. Is there any way for me to search the document and find the street names?

Thank you!

[Ron Coderre]

With
A1: containing a string...
Examples:
This is my baseball
Those are your baseballs
What is a base ball
A frisbee is not a base ball

and this list in C1:C2
baseball
frisbee

These regular formulas return TRUE if the referenced cell contains any of the list words

Please Login or Register  to view this content.

For the above example, these are the results:

Please Login or Register  to view this content.

Is that something you can work with?

[jbrennan]

Thank you Ron, that worked perfectly!

[Ron Coderre]

Glad you got something you can use!

Please be sure to mark this thread as SOLVED (from the Thread Tools menu)