Sharepoint Calculated Column Substring

Question

Hi all

Need help with a Calculated column issue in SharePoint 2007

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.

Original Column Value : mailto:[email protected] Calculated column required value: [email protected]

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

Any help?

Thanks

Answer 1

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)