View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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