| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find & delete rows based on text
I have text "phone: (then a number)" and "website: (then website)" Every
phone & website is different. I want to find these in column A and delete those rows without affect other text in this column How would I do that |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find & delete rows based on text
Find what in column A?
All we know so far is you have data in some cells. Maybe DataFilterAutofilter would work for you? Gord Dibben MS Excel MVP On Tue, 16 Sep 2008 15:31:01 -0700, deb wrote: I have text "phone: (then a number)" and "website: (then website)" Every phone & website is different. I want to find these in column A and delete those rows without affect other text in this column How would I do that |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find & delete rows based on text
I want to find any data in column a that starts with "phone:" or "website"
and delete that row "Gord Dibben" wrote: Find what in column A? All we know so far is you have data in some cells. Maybe DataFilterAutofilter would work for you? Gord Dibben MS Excel MVP On Tue, 16 Sep 2008 15:31:01 -0700, deb wrote: I have text "phone: (then a number)" and "website: (then website)" Every phone & website is different. I want to find these in column A and delete those rows without affect other text in this column How would I do that |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find & delete rows based on text
So apply data|filter|autofilter to column A.
The use a custom filter to show the rows that begin with phone: OR begin with Website: Then delete those visible rows. Then remove the data|filter|autofilter deb wrote: I want to find any data in column a that starts with "phone:" or "website" and delete that row "Gord Dibben" wrote: Find what in column A? All we know so far is you have data in some cells. Maybe DataFilterAutofilter would work for you? Gord Dibben MS Excel MVP On Tue, 16 Sep 2008 15:31:01 -0700, deb wrote: I have text "phone: (then a number)" and "website: (then website)" Every phone & website is different. I want to find these in column A and delete those rows without affect other text in this column How would I do that -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find & delete rows based on text
Run column A through autofiltercustom
begins with phone OR begins with website Ok F5SpecialVisible cells onlyOK EditDeleteEntire rows. Remove autofilter. Gord On Tue, 16 Sep 2008 16:45:01 -0700, deb wrote: I want to find any data in column a that starts with "phone:" or "website" and delete that row "Gord Dibben" wrote: Find what in column A? All we know so far is you have data in some cells. Maybe DataFilterAutofilter would work for you? Gord Dibben MS Excel MVP On Tue, 16 Sep 2008 15:31:01 -0700, deb wrote: I have text "phone: (then a number)" and "website: (then website)" Every phone & website is different. I want to find these in column A and delete those rows without affect other text in this column How would I do that |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows Based on Words | Excel Discussion (Misc queries) | |||
| find text and delete rows. | Excel Discussion (Misc queries) | |||
| Find and delete all other rows | Excel Discussion (Misc queries) | |||
| Delete rows based on criteria | Excel Discussion (Misc queries) | |||
| Delete rows based on certain criteria | Excel Discussion (Misc queries) | |||
Hybrid Mode
