title: How do I use FIND to manipulate cell text
body: <p>This is crazy. 
  I have =FIND("Model=",A3)+6 which produces 36.
  I have =FIND("|",A3,FIND("Model=",A3)+6) which produces 40.
  What does it take to get the results of 4?
  =FIND("|",A3,FIND("Model=",A3)+6)-FIND("Model=",A3)+6 produces 16.
  I am using Office 2007 with all current updates. 
  Logic says 40-36 should equal 4, but that is not what excel is producing.</p>
  
  <p>This is my test string in A3
  Year=1999|Make=Mercedes-Benz|Model=C230|Trim=Kompressor Sport Sedan 4-Door|Engine=2.3L 2295CC l4 GAS DOHC Supercharged</p>
  
  <p>The formula that I am aiming for looks kinda like this:
  =MID(A3,FIND("Model=",A3)+6,FIND("|",A3,FIND("Model=",A3)+6)-FIND("Model=",A3)+6) </p>
  
  <p>This should return the results of C230 from above text.</p>