Exporting all rows where a word was found using Find tool

[Juliette770]

I would like to somehow export from a spreadsheet all rows that contain a word in it. I can find these rows by using the "Find" tool - and when I select all the items that are found with "find all" they get highlighted on my spreadsheet but I can't figure out how to export all the rows where there is a cell that contains that word.

Basically I have a contact list of over 2K contacts and am trying to narrow it down to only certain people by finding those that have a keyword in their job title or company title columns.

thanks!

[#2 · Accepted solution]

@Juliette770

Click in the data and select Sort & Filter > Filter on the Home tab of the ribbon.

Click the filter arrow in the header of the Company or Job Title column.

Select Text Filters > Contains...

Specify a keyword and click OK.

You can then select the filtered rows, copy them and paste them elsewhere.

[#3]

perfect thank you!

[#4]

Does anyone know how to do this if the terms are spread across 30+ columns?