title: Extracting first two words from excel before colon
body: <p>I want to extract the first two words in the following cell C2 before the colon</p>
  
  <p>John Smith: Not attending today</p>
  
  <pre><code>=TRIM(LEFT(C2, FIND("~",SUBSTITUTE(C2, " ", "~ ",2)&amp;"~")))
  </code></pre>
  
  <p>I tried the above formula but it gives me "John Smith:" it gives me the colon as well</p>
  
  <p>How can I just get John Smith</p>