title: Remove middle initial only if there is one
body: <p>[![Image 1][1]][1]</p>
  
  <p><a href="https://i.stack.imgur.com/f4X09.png" rel="nofollow noreferrer">Image 2</a></p>
  
  <p>I have 1000 rows of data, some have a middle initial... some don't. I need to remove the middle initial so I am left with just first name. When I apply this.... =LEFT(B8,FIND(" ",B8,1)-1) I get an error for those cells that do not have a middle initial or name.</p>