title: Find the second space and copy remaining text using MID and SEARCH in Excel
body: <p>If I have a persons names as such</p>
  
  <pre><code>Sarah Jane Jones
  Bob Jane Smithfield
  </code></pre>
  
  <p>How do I identify the second space and copy their last name into the next cell; B1 &amp; B2 ?
  From this reference <a href="https://support.office.com/en-us/article/SEARCH-SEARCHB-functions-9ab04538-0e55-4719-a72e-b6f54513b495?ui=en-US&amp;rs=en-AU&amp;ad=AU" rel="nofollow">Excel Mid and Search Functions</a></p>
  
  <p>This example finds the first occurrence of a space and copies the subsequent characters in this case 4</p>
  
  <pre><code>=MID(A3,SEARCH(" ",A3)+1,4)
  </code></pre>
  
  <p>Following similarly</p>
  
  <pre><code>=MID(A1,SEARCH(" ",A1)+1,8)
  </code></pre>
  
  <p>returns
      Jane Jon
   and changing +2 only chops the "J" off.</p>