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

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

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

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

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