title: Excel VBA: replace entire cell with value
body: <p>Can you help me with loop that will go through cells A3:A50 and replace entire cell with a new value. </p>
  
  <p>Reference below:</p>
  
  <p><strong>[ita-IT]</strong> to <strong>IT</strong></p>
  
  <p><strong>[jpn]</strong> to <strong>JA</strong></p>
  
  <p><strong>[por-BR]</strong> to <strong>PTBR</strong></p>
  
  <p><strong>[spa-ES]</strong> to <strong>ES</strong></p>
  
  <p>etc.</p>
  
  <p>Thanks for tips!</p>