title: Telling Excel VBA TextToColumns NOT to split by spaces
body: <p>I am using VBA in Excel 2003.
  Here is the simplest example of the problem I am having.
  I want to split a string by <em>commas</em> only, into cells in the row.</p>
  
  <p>In Cell A1, I have the following string:  </p>
  
  <pre><code>A B,C
  </code></pre>
  
  <p>In VBA, if I say <code>Range("A1").TextToColumns Comma:=True,Space:=False</code>, it does what I expect.  Cell A1 is <code>A B</code> and Cell B1 is <code>C</code></p>
  
  <p>But if I have this string:</p>
  
  <pre><code>A B C,D
  </code></pre>
  
  <p>then if I use <code>Range("A1").TextToColumns Comma:=True,Space:=False</code>, it splits by <strong>SPACES</strong> anyway! Cell A1 is <code>A</code>, Cell B1 is <code>B</code>, Cell C1 is <code>C,D</code> (?!)</p>
  
  <p>Why is <code>TextToColumns</code> automatically splitting by spaces when there are more than one space, even when I <em>explicitly</em> tell it not to? Is this a known bug?
  Is there a workaround, other than manually parsing the strings into columns myself?  </p>