title: Extract characters after certain other characters Excel
body: <p>I have a list of cells that looks more or less like this:</p>
  
  <ul>
  <li>ARB:d.p.1-4-12</li>
  <li>ANT:d.p.1-12-1</li>
  <li>D:d.p.1-1-1</li>
  <li>ONN:d.p.4-2-12</li>
  </ul>
  
  <p>I'm trying to figure out how I can extract certain key elements from these strings.
  If we take the first entry as example, this is what I want to extract and display in another cell:</p>
  
  <pre><code>ARB d 1
  </code></pre>
  
  <p>I want all characters before ":", then the first character after ":" and the first number (or ONE character before the first "-").</p>
  
  <p>I've played around with TRIM, LEFT/RIGHT and FIND - but can't figure out how to get only ONE character after/before a certain character. This is what I've tried, but dont know how to limit the output to only ONE character:</p>
  
  <pre><code>TRIM(LEFT(E5;FIND(":";E5)-1))
  </code></pre>
  
  <p>Thanks in advance for any pointers or tips :-)</p>
  
  <p><strong>Update, got it working:</strong></p>
  
  <p>I ended up using this code, which was tweaked after jiggle's suggestion.</p>
  
  <pre><code>=TRIM(LEFT(E2;FIND(":";E2)-1)) &amp; RIGHT(MID(E2;FIND(":";E2);2);1) &amp; RIGHT(MID(E2;FIND("p.";E2);3);1)
  </code></pre>
  
  <p>This gave me the following output:
  ARBd1</p>
  
  <p>Now I just need to add some separators and im all good to go. Thanks for all the help.</p>