sort data by specific word in cell?

  • Thread starter Nicki_xxxxxxxxx
  • Start date
N

Nicki_xxxxxxxxx

I want to take out any rows which contain a cell which says convertible
either by sorting and deleting or by another means.
 
P

Pete_UK

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
 
Top