Pulling domains from a list of emails in excel

R

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: [email protected]
in column b return: dummydomain.com

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

Cheers in advance
 
P

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)
 
R

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)





.
Click to expand...
 
P

Peo Sjoblom

Thanks for the feedback

--

Regards,

Peo Sjoblom

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