how to copy partial data from one cell to another in excel

[Mako284]

Hello,
in cell A1 I have an email address (name@domainname.com)
in cell H1 I want to extract the domain name from A1, e.g. domainname.com

I have 4000 email addresses that I would like to extract domain names for each.

I tried =Right(A1,@) but because the domain name is right of the "@" I get an error, invalid, I don't know how to get around the invalid character?

Any suggestions? Thanks, Tom

 

[Fluff]

Hi & welcome to MrExcel
How about
=REPLACE(A1,1,FIND("@",A1),"")

 

[Mako284]

PERFECT!!!

THANK YOU!!!!

 

[Fluff]

You're welcome & thanks for the feedback.