how to strip the domain name out of an email address

[BruceThomas]

I am new to this site however hopefully someone will take pity on me and answer my question. I should also say I am only a basic Excel user (very basic). Here is my problem. I have a spread sheet with a column that contains individual email addresses (example = JoeSmith@ABC.com). I need to set up another column with just the domain name (example ABC.com). I realize I can just type it in however I have approx 14,000 entries so would be a lot of work. Is there a formula that I can use that would allow me to create a calc that strips off everything to the left of the "@" sign and only show the domain name (in this case ABC.com)?

Thanks for any help someone can provide.

 

[Rick Rothstein]

Give this formula a try...

=MID(A1,FIND("@",A1)+1,LEN(A1))

 

[jtakw]

Hi,

Just another way:

Book1
	A	B
1	JoeSmith@ABC.com	ABC.com
Sheet455

Cell Formulas
Range	Formula
B1	=REPLACE(A1,1,FIND("@",A1),"")