title: Extract last word from strings
body: <p>In Google Sheets I have string values in cells like so: </p>
  
  <blockquote>
    <p>1 Gheringhap Street, Geelong VIC 3220, Australia</p>
  </blockquote>
  
  <p>I want to extract the country value from the string. The trouble is the string values have different numbers of commas so it's hard to say at which position the last value of the cell will be. I've tried: </p>
  
  <pre><code>=INDEX(SPLIT(A2, ","), 1, 3)
  </code></pre>
  
  <p>But that only works if there are exactly two commas, if there are more or less commas then the query fails.</p>
  
  <p>Is there any other way to get the value of a string in a cell?</p>