Weed out words using Excel??

S

sensible

Is there a way to automatically isolate an appearance of a word in
list of
words, eg I have a full dictionary of words, and I want to end up wit
a
list where the word (for example) "log" appears. So if the big lis
contains:
logarithm chair table catalogue (each on a sepearte line)

The list I would want would be:

logarithm catalogue (leaving out the others)

Thanks
 
A

Andy B

Hi

Have a look at Data / Filter / Autofilter.

Andy.
PS I'd love to know where you got your text file from!!
 
Top