Need formula to extract/replace domain names from email addresses

rsaklikar

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.

Thanks!

Andrée Starå

Hi @rsaklikar

I hope you're well and safe!

Try something like this.

=RIGHT(Email@row, LEN(Email@row) - FIND("@", Email@row))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @rsaklikar

I hope you're well and safe!

Try something like this.

=RIGHT(Email@row, LEN(Email@row) - FIND("@", Email@row))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

rsaklikar

@Andrée Starå - It worked perfectly! Thank you!!!

Andrée Starå

@rsaklikar

Excellent!

You're more than welcome!