I am trying to extract data in an email address.

All the email addresses are formatted as [email protected]

Can someone please help me with a function that will extract the "last" from the email?

Note: the first and last names will always be different lengths of characters, so i think i need something that will say something like extract after the "." and before the "@"

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!