Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro that delete rows starting with specified letter/word
Let' say i have a column with with lot of cells containing various words .
I need a macro that eliminates the rows which contain that letter/word at the begining of the cell . Example , from A1 to A9 i have in the cells the following : mom , dad , son , mom , dad , son , mom , dad , son . I want to eliminate every cell that contain "mom" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DELETE ALL EXCEPT LETTER OF A WORD | Excel Discussion (Misc queries) | |||
Need a Macro that will delete every odd row starting at row number 1. | Excel Programming | |||
Macro if greater than letter then delete | Excel Programming | |||
how to delete the 1st letter form a set of rows of info. | Excel Worksheet Functions | |||
Delete Rows with letter #VALUE in cell J | Excel Programming |