ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sort data by specific word in cell? (https://www.excelbanter.com/excel-discussion-misc-queries/81341-sort-data-specific-word-cell.html)

Nicki_xxxxxxxxx

sort data by specific word in cell?
 
I want to take out any rows which contain a cell which says convertible
either by sorting and deleting or by another means.

Pete_UK

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



All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com