title: Simulate string split function in Excel formula
body: <p>I am trying to split a string in an excel formula, something like I can do in many programming languages, e.g.</p>
  
  <pre><code>string words = "some text".split(' ');
  </code></pre>
  
  <p>The problem is that I can't be sure that there is more than one word in the cell.  If I try to use the <code>FIND()</code> or <code>SEARCH()</code> functions, they return <code>#VALUE</code> if there is not space.  Is there any easy way to split the string so that it returns the individual words (or even better, so that it returns either the <em>first</em> word or <em>all the other</em> words)?</p>