Microsoft Office Forums - View Single Post - [Solved] Changing 1,2,3,15 to 1-3,15

macropod · 08-05-2014, 05:32 AM

Automating the process is as simple as calling the function with:

Code:

Sub Demo()
Application.ScreenUpdating = False
Dim i As Long
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "[0-9][0-9,]{1,}"
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    .MatchWildcards = True
    .Execute
  End With
  Do While .Find.Found
    i = i + 1
    MsgBox .Text
    .Text = ParseNumSeq(.Text, "&")
    .Collapse wdCollapseEnd
    .Find.Execute
  Loop
End With
Application.ScreenUpdating = True
MsgBox i & " sets updated."
End Sub

Note: all the output text will be in the same format as the first character (e.g. bold/superscript, etc.).