Strip Domains From List of Emails

This is a simple formula that I use to strip domains (such as “hotmail.co.uk”) from long lists of email addresses in Google Sheets:

=IF(NOT(ISBLANK(A2)),RIGHT(A2,LEN(A2)-FIND("@",A2)), )

This code simply checks if A2 is blank and then if it’s not it attempts to return everything after the “@” symbol within that cell.

Before:

example@hotmail.co.uk

After:

hotmail.co.uk

If this helps you in any way feel free to leave a like or a comment!