Move partial data from one Column two another Column in Excel
<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>