title: Extract the last substring from a cell
body: <p>I have names in a column.  I need to split just the last names from that column into another column. </p>
  
  <p>The last name is delimited by a space from the right side.</p>
  
  <p>The contents in cell <code>A2 = Alistair Stevens</code> and I entered the formula in cell <code>B2</code> (I need <code>'Stevens'</code> in cell <code>B2</code>)</p>
  
  <p>I tried using the following formulas:  </p>
  
  <pre><code>=RIGHT(A2,FIND(" ",A2,1)-1)
  
  =RIGHT(A2,FIND(" ",A2))
  </code></pre>
  
  <p>Both these formulas <strong>work</strong> for this cell but when I fill it down / copy and paste it for the cells below it doesn't work. I get the wrong values!!</p>
  
  <pre><code>A3 -&gt; David Mckenzie
  
  B3 -&gt; Mckenzie
  </code></pre>