How to extract the email address from column having Contact Type

Options

Here in the "PM Name" column, I have a value which is of Contact type. I tried copying the value over to the next column, then i get the Email address Prefixed by my name(Manasa M S<manasa@gmail.com>).In the next column I want to extract only the email address(eg: manasa@gmail.com). please share if you have formula for this problem.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!