title: How to extract the last part of the string in Excel after the last underscore
body: <p>I have the following example data:</p>
  <pre><code>1. animated_brand_300x250
  2. animated_brand_300x600
  3. customaffin_greenliving_solarhome_anim_outage_offer
  </code></pre>
  <p>How to extract the string from the last underscore in Microsoft Excel?</p>
  <p>I want to extract the value before the first underscore and after the last underscore.</p>
  <p>First underscore:</p>
  <pre><code>=LEFT(B6,SEARCH(“_”,B6)-1)
  </code></pre>
  <p>would return <code>animated</code> and <code>customaffin</code> as output.</p>
  <p>How to return the string after the last underscore?</p>