Need formula to extract/replace domain names from email addresses

Options

I have a column with several hundred email addresses. The emails are in all different formats (first.last@xyz.com, first initial last name@xyz.com ... that sort of thing. I need a formula that extracts/replaces the email address with the domain only. So john.doe@xyz.com becomes xyz.com ... and jdoe@xyz.com becomes xyz.com

In Google Sheets, I use this formula .. =REGEXREPLACE(C2,"(.*)@","") ... and it works perfectly. I just can't figure out how to do it in SmartSheet.

Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!