title: Excel MATCH text but return a value to left or right depending on other text
body: <p>I have a terribly inelegant formula to return a value from the left or the right of a string depending on the MATCH.  It works, but I am hoping that someone can help with making this a bit easier to read.
  The general read of the formula is:</p>
  
  <ul>
  <li>If you find (<code>MATCH</code>) "*TestSpec;*"</li>
  <li>Then return the value to the Right of the semicolon</li>
  <li>Else, return the value to the Left of the semicolon</li>
  <li>Further: if the Value is not shown, then do nothing </li>
  </ul>
  
  <p>My problems are: </p>
  
  <ul>
  <li>The <code>IF</code> statement by itself can only return either the LEFT or the RIGHT </li>
  <li>The <code>MATCH</code> statement returns a Boolean so it's not helpful in determining LEFT or RIGHT </li>
  <li>2 <code>IFERROR</code> statements </li>
  </ul>
  
  <p>Here's the Excel Formula in all it's glory:</p>
  
  <pre><code>=IFERROR( 
     IFERROR(
       IF(MATCH("TestSpec;*",Table1[@Tags],0), 
         RIGHT(Table1[@Tags],LEN(Table1[@Tags])-FIND(";",Table1[@Tags])-1)
       ), \*End IF no alternate value if false*
       LEFT(Table1[@Tags],FIND(";",Table1[@Tags])-1) 
     ), \*First Error Catch*  
   "") \*Second Error Catch*
  </code></pre>
  
  <p>Sample Input Values:</p>
  
  <ul>
  <li>Customer; TestSpec </li>
  <li>Report; TestSpec </li>
  <li>Charting; TestSpec</li>
  <li>ProgramOptions; TestSpec </li>
  <li>TestSpec; WeatherZone</li>
  </ul>
  
  <p>Output should just show: </p>
  
  <ul>
  <li>Customer </li>
  <li>Report </li>
  <li>Charting </li>
  <li>ProgramOptions </li>
  <li>WeatherZone</li>
  </ul>