title: Move entire contents of cell based on whether it contains a specific character-Excel 2007
body: <p>I want to create a macro in Excel 2007 to search Column A for a colon (:) and if found, move the entire cell value into the same row Column B. Thus it my data looks like this:</p>
  
  <pre><code>Column A     Column B
  1:256   
  13.049 
  1:200    
  1:100   
  1:200   
  1:512   
  &gt; 1:512 
  13.909
  1:100   
  1:512   
  1:512   
  16.610
  </code></pre>
  
  <p>And to look like this post running macro:</p>
  
  <pre><code>Column A    Column B
              1:256   
  13.049 
              1:200     
              1:100   
              1:200      
              1:512   
              &gt; 1:512 
  13.909
              1:100   
              1:512        
              1:512   
  16.610
  </code></pre>
  
  <p>Ideas anyone?</p>