Need formula to extract/replace domain names from email addresses

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

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!