Taking out domain names out of e-mail adresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pilaarbijter - 20 Sep 2006 08:33 GMT

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

Reply to this Message

Bob Phillips - 20 Sep 2006 08:42 GMT

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

Signature

HTH

Bob Phillips

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

> Hello,
>
[quoted text clipped - 5 lines]
>
> Ruben

Reply to this Message