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.
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.
- perfect thank you!
