title: sharepoint calculated column
body: <p>I would ike to get just the email address from the column :Email From" in sharepoint 2007. Can  anyone please help me wrting the formula to get the  email id.</p>
  
  <pre><code>old value : abc, def &lt;dabc@dxxx.com&gt;
  expected value: dabc@dxxx.com
  </code></pre>
  
  <p>How to write the expression so that i get something like that. Please help me.</p>
  
  <p>I have added something like below in the calculated column, but somehow i cannot rip '>' symbol</p>
  
  <pre><code>=MID([E-Mail From],FIND("&lt;",[E-Mail From])+1,FIND("&gt;",[E-Mail From])-1)
  </code></pre>
  
  <p>and the o/p is</p>
  
  <pre><code>dabc@dxxx.com&gt;
  </code></pre>