Weed out words using Excel??

M

mike flanagan

Weed out words using Excel??
Is there a way to automatically isolate an appearance of a word in a list of
words, eg I have a full dictionary of words, as a text file, and I want to
end up with a
list where the word (for example) "log" appears. So if the big list
contains:
logarithm chair table catalogue (each on a seperate line)

The list I would want would be:

logarithm catalogue (leaving out the others)

Thanks.
 
P

Paul Falla

Dear Mike

Using cutom filtering might be the answer here. To do this
open the "Data" menu and select "Filter"
then "Autofilter". once the worksheet has changed to show
dropdown boxes at the column headers, click on the drop
down in the relevant column and select "custom" from the
list. In the dialogue box choose "contains" from the drop
down list of options and then type in "log" in the values
field.

Hope this helps

Paul Falla
 
Top