title: String split and count in Excel
body: <p>I have the following column <code>K</code> in Excel:</p>
  
  <pre><code>  K           
  2 Apps -                                                            
  3 Appointed CA - Apps - Assist - Appointed NA - EOD Efficiency
  4 Appointed CA -
  5 Appointed CA -
  </code></pre>
  
  <p>I want to split at <code>-</code> and count the number occurrences of the specific words in the string.</p>
  
  <p>I tried the following formula which splits my string and returns everything <code>LEFT</code> to the <code>-</code></p>
  
  <pre><code>=LEFT( K2, FIND( "-", K2 ) - 2 )
  </code></pre>
  
  <p>But the ideal output should be:</p>
  
  <pre><code>Apps      Appointed CA       Assist    Appointed NA        EOD Efficiency
  1
  1           1                 1           1                  1
              1
              1
  </code></pre>
  
  <p>Based on the above data.</p>
  
  <p>Regards,</p>