title: Word 2007 - How do I convert text with inconsistent tabbing to a table?
body: <p>I have a whole bunch of tables that were formatted weird, because when a bunch of people make tables out of tabs, one cannot expect the tabbing to be consistent on all of them.</p>
  
  <p>For example... I have this table: 2 cols by 11 rows... but I would like a macro that didn't care about the number of columns and rows</p>
  
  <pre><code>space space space **column header** tab tab tab tab **column header**
  tab **data** tab tab tab **data** tab tab
  tab **data** tab tab **data**
  tab **data** tab tab tab tab **data**
  tab **data** tab tab **data**
  </code></pre>
  
  <p>Currently, I have this macro</p>
  
  <pre><code>Sub ConvertTextToATable()
  
       Selection.ConvertToTable Separator:=wdWhite, AutoFitBehavior:=wdAutoFitFixed
  
  End Sub
  </code></pre>
  
  <p>I've tried the tab separator... but both give similar results.  It creates a new column every time a new white space character is encountered.  What I want is ignoring all white space, and creating a new cell every time text is encountered, and creating a new row every time \n or \r is encountered.</p>
  
  <p>And since I can't guarantee that every table with have the same number of column headers as the data, I think the number of columns should be determined by the second or third row in the text of original pseudo table.</p>