This may not be the type of help you desire,
but Excel can only find one piece of text at a time so...

My commercial Excel add-in "XL Companion" has a Find and List
feature that will find and list the location of multiple items.
It generates a new sheet with a copy of the found row including the
sheet name it was found on and the row number.
It can do up to 255 characters at a time...
sludge;slop;slippery;slick and so on, as one entry.
Free 3 week trial, just email and ask for it.
--
Jim Cone
Portland, Oregon USA
)




"golden"

wrote in message
...
Thank you Max but I have a bad habit of not explaining myself, sorry.
I have a worksheet and I'm trying to find word, computer, excel, work,
house, yard, study and I'm trying to make a graph of the hours I have spent
in each item so I can figure out my study habits and this is for the last
year. So I need to find about a half a dozen word in about 400 rows. I want
to put in all the words so I only have to go throw the spreadsheet once. I
don't know the how. I tried, commas, colons and a lot more but just don't
know and the help on office 2007 is not very good or I just don't know how to
use it. Could you help me please.
Thank you

"Max" wrote:

Perhaps autofilter on a helper col will be potent enough?
Assume source data in A2 down
Assume your list of words to find is in F2:F5 ie: dog, cat, house, car
Put in B2: =COUNTIF($F$2:$F$5,A2)
Copy down to last row of source data. Col B returns 1 where the source word
in col A is found in your list. Autofilter on col B, choose: 1. You got it.
Aha? Hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"golden" wrote:
Find: dog, cat, house, car,
How do I do this?