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