title: Get first item from Split()
body: <p>I use the <a href="https://support.google.com/docs/answer/3094136?hl=en">SPLIT</a> function to split a string which looks something like <code>1.23/1.15</code>.</p>
  
  <p>Right now it yields two cells, as it should. But how do I get a certain element from the result? I would like to do something like this:</p>
  
  <pre><code>SPLIT("1.23/1.15", "/")[0]
  </code></pre>
  
  <p>to extract <code>1.23</code>. What is the correct syntax for that?</p>
  
  <p>I tried using the <code>INDEX</code> function, without success: <code>=INDEX(SPLIT("1.23/1.15", "/"), 0,0)</code></p>