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