Sharepoint Calculated Column Substring

Need help with a Calculated column issue in SharePoint 2007

Basicall开发者_C百科y, I'm trying to take the value from the [Contact E-Mail Address] column and remove the mailto: part infront which Sharepoint automatically created.

Original Column Value : mailto:foo@fooo.com Calculated column required value: foo@fooo.com

This is what i've got so far : =RIGHT([Contact E-Mail Address],11)

Any help?

Thanks

How about:

=RIGHT([Contact E-Mail Address],LEN([Contact E-Mail Address])-7)

or

=SUBSTITUTE([Contact E-Mail Address],"mailto:","")

Adapted from Excel Tips (calculated columns use Excel functions)