I am trying to extract data in an email address.


All the email addresses are formatted as first.last@domain.com

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!