| 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 | |||
Linear Mode
