title: Take only part of a string in VBA
body: <p>So I have this string in Excel: MS15-077[3077657]</p>
  
  <p>and I just want to take the first part, MS15-077 to use to compare against other strings. Is there a way to just take the first 8 characters of the cell contents and set that as a variable?</p>
  
  <p>Thanks!</p>