string functions

[Drew Kennelly]

Hi there, does anybody know how to extract the domain name from an email
address.

I have a list of email address in column A, in coloumn I would like to
output the domain for each row.

e.g. (e-mail address removed) (column A) would return yourcompany.com (column B)

any help on how this could be done, assuming each row contains a valid email
address.

Thanks in advance

Drew Kennelly

 

[Frank Kabel]

Hi
try
=MID(A1,FIND("@",A1)+1,1024)