title: Using Regex to replace space with newline in VBA
body: <p>I have the following string:</p>
  
  <pre><code>ABCD1234  ABCD1234
  </code></pre>
  
  <p>I'd like to replace the double space with newline, but preserve any text following the space</p>
  
  <p>Here's what I'm trying:</p>
  
  <pre><code>.Replace what:="  *", replacement:=Chr(10), lookat:=xlPart
  </code></pre>
  
  <p>It does replace the space with newline, but removes the rest of string following the space</p>
  
  <p>I'd like the replace action to only match cases where there is text after the string</p>