Weed out words using Excel??

[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

 

[Andy B]

Hi

Have a look at Data / Filter / Autofilter.

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

 

[sensible]

Great result.....solves the problem....thanks