Pat,
I don't think the filter can be set up to filter what you need directly, but
it could be done via a helper column:
=ISNUMBER(SEARCH(" ",A2,1))
Filter for FALSE
=NOT(ISNUMBER(SEARCH(" ",A2,1)))
Filter for TRUE
Or, for a better presentation:
=IF(NOT(ISNUMBER(SEARCH(" ",A1,1))),"yes", "no")
Here you can put in your own values to appear in the helper column. Change
the "yes" and "no" to suit.
These will return incorrect results if there are spaces at the beginning or
ending of the values. If that's a possibility, those should be removed, or
the formulas here changed:
=IF(NOT(ISNUMBER(SEARCH(" ",TRIM(A2),1))),"yes", "no")
--
Earl Kiosterud
www.smokeylake.com
"Pat" wrote in message
...
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