S
SteveG
I have a long text file from which I want to extract blocks of data.
As a text import all the text starts in Column A. There are about
1000 lines in each file.
I want to:
1) Search for a word "apple" within each string/row then
2) Search for another word "bacon" in another string/row then ...
3) Select and hide the rows from row "apple" to row "bacon"
4) Repeat for the next occurance "apple" to "bacon". There are 29
occurances in each file.
Once I am sure that I have the correct selection I would then delete
the hidden rows.
Any ideas?
As a text import all the text starts in Column A. There are about
1000 lines in each file.
I want to:
1) Search for a word "apple" within each string/row then
2) Search for another word "bacon" in another string/row then ...
3) Select and hide the rows from row "apple" to row "bacon"
4) Repeat for the next occurance "apple" to "bacon". There are 29
occurances in each file.
Once I am sure that I have the correct selection I would then delete
the hidden rows.
Any ideas?