Hello,
I am trying to filter a column of text, and unsure how to or if this is possible. Each Cell contains 1 sentence, with roughly ~3000 cells in the column.
I have a list of words I want to use as keywords for filtering the column of text. I would ideally like to use a text file, so I can keep a tidy track of the keywords. Is it possible, and if so how would I then use the list of words/.txt file in order to filter the column of text in excel.
In practical terms to make things easier. I have a column of ~3000 sentences, and need to filter for only the sentences which contain company names (these will be in the text file as a list).
How would I go about doing this? If you have any questions, which would lead you to be able to help me, please do not hesitate!
Thanks in advance!
Nitesh
Bookmarks