title: Using replace with regular expressions - VBA
body: <p>I would like to format a text. I mean something like this:
  I'd like to transform this: </p>
  
  <pre><code>"something'text between apostrophes'text"
  </code></pre>
  
  <p>into </p>
  
  <pre><code>"something 'text between apostrophes' text"
  </code></pre>
  
  <p>I want to add spaces from both sides, but keep te string in '' the same. 
  I tried to do it like this:</p>
  
  <pre><code>  Arkusz1.Cells(1, 1).Replace What:="'*'" Replacement:=" '*' "
  </code></pre>
  
  <p>But its result is: </p>
  
  <pre><code>"something '*' text"
  </code></pre>
  
  <p><code>Arkusz1.Cells(1,1)</code> contains the <code>string</code> I want to replace. Is it possible to do this? 
  Thanks</p>