title: VBA to only keep cell value before space
body: <p>It seemed like a simple code but I couldn't find it anywhere on the net &amp; I don't know how to write it.</p>
  
  <p>What I want to do is that, say, cell range A1 has a value of "Hey ho he ha".
  What I want the code to do is to remove away the rest of the word after the 1st space, so what's left will be with only "Hey".</p>
  
  <p>Thanks!</p>