Extract a domain name from an email address

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.

The formula is fine, but you need to:

1. Include the = sign at the front of it and
2. Replace the unicode quote marks with ASCII ones - if you type that formula in rather than cutting and pasting it then it will work fine.

If you want to include the @ symbol you'll need to add +1 inside the final close bracket.

That worked - thanks so much for your help!

I used
=RIGHT(A1;((LEN(A1)-FIND("@";A1))))
but have not been able to get this to work.

The curser in the details area "hangs up" by highlighting the first A1. I changed the quotes around the @ to asci.

I am in Excel 2007. Any help appreciated.