Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 03-20-2017, 03:46 PM
macropod's Avatar
macropod macropod is offline Select and Delete 2 lines after each blank line Windows 7 64bit Select and Delete 2 lines after each blank line Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Ziad El Hachem View Post
I would really like to delete all blank lines along with the next 2 bad lines. I only know this is possible in VBA!
You almost certainly don't need VBA for this; a wildcard Find/Replace would most likely do the job, where:
Find = ([^13^l])[^13^l]{1,}
Replace = \1
This assumes there are no stray spaces, tabs, etc. in your 'blank' lines.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
blank find expand



Similar Threads
Thread Thread Starter Forum Replies Last Post
Select and Delete 2 lines after each blank line Line Numbering & Blank Lines Ephasa Word 9 04-30-2020 02:09 PM
Quickly select lines of certain colour RFoudy PowerPoint 27 09-09-2014 12:35 AM
Select and Delete 2 lines after each blank line remove blank lines in between jolinchew Excel 4 08-01-2013 06:09 AM
Select and Delete 2 lines after each blank line Getting blank lines instead of supressed lines. Welshie82 Mail Merge 2 11-14-2011 01:41 AM
Select and Delete 2 lines after each blank line How to turn all blank lines into non-blank for legal forms sieler Word 3 04-12-2009 01:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft