View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default sort data by specific word in cell?

You can filter the column using Custom | Contains and then enter your
word. Then highlight the visible rows and Edit | Delete Row, then
select All in the filter pull-down.

Hope this helps.

Pete