Taking out domain names out of e-mail adresses

P

Pilaarbijter

Hello,

In Excel I have a column with a few e-mail addresses. And I was wondering
if it's possible to take the domain name out of the e-mail address and put
them in the column next to it?



Thanks,

Ruben
 
B

Bob Phillips

=RIGHT(A1,LEN(A1)-FIND("@",A1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top