title: Move partial data from one Column two another Column in Excel
body: <p>On program start, Column <code>A:A</code> contains:</p>
  
  <pre><code>123456789123456-BC123456  
  321654987654321-AD741258  
  369852147258961-FG369852  
  AS426953-153953751153369  
  DF714258-957456351456321  
  VB153965-233654963147456  
  </code></pre>
  
  <p>I would like to move the <code>KK000000</code>-type data to column <code>B:B</code>. After the move, Column <code>A:A</code> Would contain:</p>
  
  <pre><code>123456789123456  
  321654987654321  
  369852147258961  
  153953751153369  
  957456351456321  
  233654963147456  
  </code></pre>
  
  <p>And Column <code>B:B</code> would contain:</p>
  
  <pre><code>BC123456  
  AD741258  
  FG369852  
  AS426953  
  DF714258  
  VB153965  
  </code></pre>
  
  <p>How do I accomplish this?</p>