title: Use cell value as string VBA
body: <p>Cell A2 contains value "25-86".</p>
  
  <p>I need cell B2 to have value "AJ 2586%" </p>
  
  <p>This code reveals Syntax error:</p>
  
  <pre><code>Range("B2").Value = "AJ &amp; Left(Range("A2"), 2) &amp; Right(Range("A2"), 2) &amp; %"
  </code></pre>
  
  <p>If I write it like that </p>
  
  <pre><code>Range("B2").Value = "AJ &amp; Left(A2, 2) &amp; Right(A2, 2) &amp; %"
  </code></pre>
  
  <p>The functions <code>Left</code> and <code>Right</code> treat "A2" as string.</p>
  
  <p>How could I extract a part of text from the cell and enter it in another cell?</p>