Manually???

Just find that troublesome word
then hit ctrl-shift-home
then Edit|Delete...|Entire row



Farooq Sheri wrote:

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

--

Dave Peterson