Thread: [Solved] Select and Delete 2 lines after each blank line
View Single Post
 
Old 03-20-2017, 01:24 PM
Ziad El Hachem Ziad El Hachem is offline Windows 7 64bit Office 2003
Novice
  
Join Date: Mar 2017
Posts: 2
Ziad El Hachem is on a distinguished road
Question Select and Delete 2 lines after each blank line
Dear all,

I have large amounts of text that can be seen as the following pattern:

Good Line
(empty line)
Bad Line
Bad Line
Good Line
(empty line)
Bad Line
Bad Line

Etc...
I would really like to delete all blank lines along with the next 2 bad lines. I only know this is possible in VBA! but I am not proficient in it (my experience is with excel VBA)
Reply With Quote