Thanks again David, that worked fine.

Is there a way to filter a list where repeated words are filtered out to
reveal only one instance of each word.


"David Hepner" wrote in message
...
DataFilterAutofilter...
Customdoes not contain(space - hit space bar once)

"Pat" wrote:

How should i go about filtering a column to return only those cells
where
there is a single word contained in them and leave out those cell where
there is a string of text.

Example

Abelia
Abelia chinensis
Abies
Abies alba
Abromeitiella
Abromeitiella brevifolia
Abutilon
Abutilon 'Anneke'


after filtering returns
Abelia
Abies
Abromeitiella
Abutilon

Thanks if you can help.
Pat