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 xyz.com ... and [email protected] 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.
Help Article Resources
Check out the Formula Handbook template!