Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort but keep linked formulas? | Excel Discussion (Misc queries) | |||
Sort Data Out of One Cell | Excel Discussion (Misc queries) | |||
macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
delete cell that doesn't contain a specific word | Excel Discussion (Misc queries) | |||
Getting specific data from a word document into an excel sheet | Excel Worksheet Functions |