I have a massive list of email addresses, and I need a formula to easily extract the domain name from each.
For example, in cell A1 I have the email address: [email protected]
In cell B1, I want to extract just the domain name: @northpole.com
I found the following formula, but I keep getting an error when I try to use it: =RIGHT(A1,((LEN(A1)-FIND(“@”,A1))))
Attached is a sample excel file.
Bookmarks