View Single Post
  #1   Report Post  
Farooq Sheri
 
Posts: n/a
Default Want to delete rows

I have text file which I import into Excel. There is a particular string
which I need to find (this can be in any row) so the row position is
variable. I can find this string no problem. What I want to do is once I find
the string, then starting from the row where the string is located, I want to
delete all rows above including the row in which the desired string is
located.

e.g the string is at Row 27, delete rows 1-27.

Thanks