title: Excel function to get first word from sentence in other cell
body: <p>Excel: What function can I use to take the all the characters from the beginning to the first '&lt;". I am trying to strip out the first word from A1 and put it into B1</p>
  
  <p>Eg:</p>
  
  <pre><code>A1
  Toronto&lt;b&gt; is nice
  </code></pre>
  
  <p>I want "Toronto" in the next cell.</p>
  
  <p>Ian</p>