title: VBA parse string into tokens
body: <p>I've got a string with a bunch of multi-letter codes in it and I'd like to parse it out according to those codes. I'm not sure how to make it look at more than one character to determine if it forms part of a code.</p>
  
  <p>My string looks like this:</p>
  
  <p>BBCTEEBOBBB</p>
  
  <p>and I want to parse out these instances:</p>
  
  <p>E
  BB
  CT
  BOB</p>
  
  <p>So the result should be output (or an array) that looks like this:</p>
  
  <p>BB
  CT
  E
  E
  BOB
  BB</p>