Microsoft Office Forums - View Single Post - [Solved] Remove hyphenation from copied text from pdf in Word VBA

Guessed · 03-20-2024, 09:48 PM

Try this version which works on your brief sample - it appears the dash is using the extended Ascii codes.

Code:

Sub Macro1()
  With ActiveDocument.Range.Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = ChrW(8209) & " "
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchKashida = False
    .MatchDiacritics = False
    .MatchAlefHamza = False
    .MatchControl = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
    .Execute Replace:=wdReplaceAll
  End With
End Sub