=MID(A1,FIND("@",A1)+1,FIND(".",A1,FIND("@",A1)+1)-FIND("@",A1)-1)

and copy down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Laura Vanhoorelbeke" wrote in message
...
Hi,

I have been working on a worksheet in Excel and I have placed all my
Email Addresses in my Column A. Now I want to have all the domain names in
my column B.
For example:
Cel A1:
Cel B1: hotmail

Now my question is, how can I do this with only 1 formula?

Thank you for helping me.