title: select the last non-empty cell in excel range
body: <p>I have a sheet with many rows look like this</p>
  
  <pre><code>Castle Green     Taunton TA1 1NF             UK         
  11 Bacon Ln      Moranbah QLD 4744           Australia          
  40 Memory Ln     Hunter River                PE C0A 1N0      Canada     
  Fidel Velazquez  Av Fidel Velázquez #3000    Col. Central    Central     64190 Monterrey     Mexico
  </code></pre>
  
  <p>I need to collect the last cell in each row in one new column. So, the new column shall look like:</p>
  
  <pre><code>UK
  Australia           
  Canada      
  Mexico
  </code></pre>
  
  <p>Thanks a lot. </p>