Are you looking for the string in just one column?

If yes, then maybe you could apply Data|Filter|Autofilter to that column.
Filter on that column (Custom|contains (yourstringhere))
then copy the visible rows and paste whereever you want.


Scott H wrote:

I am looking for data in a spreadsheet containing a certain word. If i do a
Find All,
I am given all of the rows that contain the word. Is there a way to then
copy all of that data, or the specific rows that contain the keyword?

I find myself clicking each line found in find all, going back to the
spreadsheet, copying and pasting in a new spreadsheet. I then keep repeating
this task. there has to be a better way.

thank you,

--

Dave Peterson