Automatically Convert Text to Table with unique character as deliminator

macropod · #4 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Row seperator control character in Text To Table	AndreQ	Word Tables	2	04-12-2019 07:23 AM
How to convert VLOOKUP values to text on another sheet AUTOMATICALLY	Lady18	Excel	5	09-10-2016 03:12 AM
How to convert VLOOKUP values to text on another sheet AUTOMATICALLY	Lady18	Excel	1	09-10-2016 12:15 AM
Convert Text To Table: Separate text at (Other)?	tinfanide	Word VBA	2	01-12-2015 05:26 AM
Convert graphic to text in a table	Jennifer Murphy	Word	6	01-24-2013 12:56 PM