LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Pat
 
Posts: n/a
Default Filter on first part of string

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
superscript in part of a string when using concatenate Ged2 Excel Discussion (Misc queries) 1 August 23rd 05 02:47 PM
Extract Part of String [email protected] Excel Worksheet Functions 1 June 9th 05 08:33 AM
select part of a cell value string rich_j_h Excel Discussion (Misc queries) 2 May 19th 05 11:36 AM
Summing part of an Alpha Numeric String Arturo Excel Worksheet Functions 2 February 23rd 05 09:59 PM
Part Number/Qty Consolidations [email protected] Excel Discussion (Misc queries) 2 February 6th 05 09:21 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"