Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete ALL cells containing the same data
Cell Contains
A1 000000001 A2 000000002 A3 000000003 A4 000000003 A5 000000004 A6 000000005 A7 000000006 A8 000000007 A9 000000007 A10 000000008 A11 000000008 A12 000000009 A3 and A4 contain 000000003. Data/Remove Duplicates deletes all but one cell containing 000000003. Is there a way to delete ALL cells containing 000000003? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete cells with a given data? | Excel Discussion (Misc queries) | |||
delete columns if cells have no data | Excel Discussion (Misc queries) | |||
Delete cells containing specific data? | Excel Discussion (Misc queries) | |||
How do I delete only part of the data in a row of cells? | Excel Worksheet Functions | |||
using a macro to delete duplicate data (cells) | Excel Programming |