title: copy last value of a cell into a cell of another column
body: <p>In an Excel column, either there is one value (alphanumerical) that I should copy to the cell of the same row but in another column or there are more than one value separated by space and I should copy the last one in to the other column. The values have the same format, digits 5 or 6 followed by a character and three digits (8 or 9 chars). How can I copy correctly if there is one value in the other column and if there are more than one value the last one on 8 or 9 characters?</p>
  
  <p>Thanks</p>
  
  <p><a href="https://i.stack.imgur.com/oK3jC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oK3jC.png" alt="enter image description here"></a>
  Carol</p>
  
  <p><a href="https://i.stack.imgur.com/fWA6g.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fWA6g.png" alt="enter image description here"></a></p>