title: Copy from one column to another , entire column to specific text
body: <p>I know this is bit difficult but i wonder if any one can help.
  I want to copy one entire column data in to other column but When we copy the data , it should only replace one specific word in that column , Not entire content.</p>
  
  <p>For example </p>
  
  <pre><code>Column A    
  1234        
  5252         
  3265         
  999        
  
  Column B
  
  This is **
  
  This is **
  
  This is **
  
  This is **
  </code></pre>
  
  <p>I want to replace Column A data to Column B data but it should only replace ** , So whatever is in the column A will be replaced by ** in Column B , but it should not alter any other text in Column B</p>
  
  <p>I wonder if anyone can solve this? Any macro in excel? it is just a find and replace macro but more complicated</p>