![]() |
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. |
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