Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-28-2015, 12:44 AM
gmayor's Avatar
gmayor gmayor is offline macro to delete line break Windows 7 64bit macro to delete line break Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

First of all the first set of brackets is superfluous
Find: ^13([a-z])
Replace: \1
would achieve the same result - http://www.gmayor.com/replace_using_wildcards.htm

As for a macro, select the text that you wish to process and run

Code:
Sub RemoveParaOrLineBreaks()
Dim oRng As Range
Dim oFind As Range
    Set oRng = Selection.Range
    Set oFind = Selection.Range
    With oFind.Find
        Do While .Execute(FindText:="[^13^l]{1,}", MatchWildcards:=True)
            If oFind.InRange(oRng) Then
                oFind.Text = ""
            End If
        Loop
    End With
    Set oFind = oRng
    'Optionally remove additional spaces
    With oFind.Find
        Do While .Execute(FindText:="[ ]{2,}", MatchWildcards:=True)
            If oFind.InRange(oRng) Then
                oFind.Text = Chr(32)
                oFind.Collapse 0
            End If
        Loop
    End With
    'end of option
lbl_Exit:
    Set oRng = Nothing
    Set oFind = Nothing
    Exit Sub
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Last edited by gmayor; 05-28-2015 at 05:02 AM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to delete line break Can't delete page break John Holstein Word 5 04-01-2015 09:00 AM
Line break between en dash and number 90-degree Word 1 01-14-2015 01:09 PM
macro to delete line break How can I remove line break from 4 dash's nmss18 Word 2 09-11-2014 06:07 AM
macro to delete line break delete page break seeker62 Word 3 07-22-2013 06:49 PM
macro to delete line break Delete Page Break using VBA wordpunk Word VBA 1 07-03-2012 03:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:38 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