Forum Discussion
Solved
Exporting all rows where a word was found using Find tool
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" t...
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.
Does anyone know how to do this if the terms are spread across 30+ columns?