find & delete rows based on text

[deb]

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

 

[Gord Dibben]

Find what in column A?

All we know so far is you have data in some cells.

Maybe Data>Filter>Autofilter would work for you?


Gord Dibben MS Excel MVP

 

[deb]

I want to find any data in column a that starts with "phone:" or "website"
and delete that row

 

[Dave Peterson]

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

 

[Gord Dibben]

Run column A through autofilter>custom

begins with phone

OR

begins with website

Ok

F5>Special>Visible cells only>OK

Edit>DeleteEntire rows.

Remove autofilter.


Gord