| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
delete cell that doesn't contain a specific word
I'm trying to delete a cell in excel if the content of the cell doesn't
have a specific word. For example if I only wanted cells if it contained the word 'John' in it. Then the cell: I love excel - would be deleted but the cell: I love excel more than John - would not be deleted. I'm sure it's probably a simple solution but I'm not really sure how to do this. Any help would be much appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use word wrap in a merged cell in excel 2000? | Excel Discussion (Misc queries) | |||
| in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
| Specific cell values | Excel Discussion (Misc queries) | |||
| Hyperlink a word within a cell | Excel Discussion (Misc queries) | |||
| How do you delete a cell then shift cell up? | Excel Discussion (Misc queries) | |||
Threaded Mode
