Microsoft Office Forums - View Single Post - [Solved] Automatically Convert Text to Table with unique character as deliminator

macropod · 06-13-2019, 01:48 AM

Well, obviously, you'd only use the process I outlined for the ranges that should be converted to tables, not to the whole document. For a macro, you might try something like:

Code:

Sub Demo()
Application.ScreenUpdating = False
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "?"
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
    .Execute
  End With
  Do While .Find.Found
    .Paragraphs.First.Range.ConvertToTable Separator:="?", AutoFit:=True, _
      Format:=wdTableFormatList3, AutoFitBehavior:=wdAutoFitContent
    .Collapse wdCollapseEnd
    .Find.Execute
  Loop
End With
Application.ScreenUpdating = True
End Sub