Pulling domains from a list of emails in excel

[Rosie]

I have a list of email addresses in column A, In column b
I want to pull out the domain address from the email using
a formula

eg: in column A: (e-mail address removed)
in column b return: dummydomain.com

anyone got a snazzy forumal that will do the trick and
save me time?

Cheers in advance

 

[Peo Sjoblom]

One way

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

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Rosie]

Thanks that worked a treat Peo

-----Original Message-----
One way

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

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)





.

 

[Peo Sjoblom]

Thanks for the feedback

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)