title: Sharepoint Calculated Column Substring
body: <p>Need help with a Calculated column issue in SharePoint 2007</p>
  
  <p>Basically, I'm trying to take the value from the [Contact E-Mail Address] column and remove the mailto: part infront which Sharepoint automatically created.</p>
  
  <p>Original Column Value : mailto:foo@fooo.com
  Calculated column required value: foo@fooo.com</p>
  
  <p>This is what i've got so far :
  =RIGHT([Contact E-Mail Address],11)</p>
  
  <p>Any help?</p>
  
  <p>Thanks</p>