title: Substring in VBA
body: <p>I have multiple strings in different cells like</p>
  
  <pre><code>CO20:  20 YR CONVENTIONAL
  FH30:  30 YR FHLMC
  FHA31   
  </code></pre>
  
  <p>I need to get the substring from 1 to till index of ':' or if that is not available till ending(in case of string 3). I need help writing this in VBA.                                                                                                                          </p>