Withdraw domain name from mail address

  • Thread starter Thread starter Xavier Vanmeerhaeghe
  • Start date Start date
X

Xavier Vanmeerhaeghe

Hi,

If i have a column with mail addresses.
Is it possible then to withdraw the domain name from the address to the
column next to it?
example: cell A1= (e-mail address removed), cell A2=
(e-mail address removed), and so on.
cell B1= domainname33, cell B2= domainname99
thanks in advance!

With kindest regards,
Xavier Vanmeerhaeghe
 
If the final . is always followed by three letters .com .org .edu etc...

=LEFT(MID(A1,FIND("@",A1)+1, LEN(A1)),LEN(MID(A1,FIND("@",A1)+1, LEN(A1)))-4)

HTH,
Bernie
MS Excel MVP
 
Gary''s Student,

That gives "somebody", not "domainname33"

HTH,
Bernie
MS Excel MVP
 
Hi Xavier

Owing to email addresses varying so much, the formula become a little
involved.
Potentially you could have an email address such as
(e-mail address removed) so you need to search for "@", then find the
first "." after it and extract the data between.

I think the formula below should do it

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

The address can also have subdomains:

(e-mail address removed)

and this.that would be the appropriate domain.... so that is another thing to check for.

But only Xavier can tell which is best.

HTH,
Bernie
MS Excel MVP
 
Bernie Deitrick said:
Ian,

The address can also have subdomains:

(e-mail address removed)
Click to expand...

Good point.
and this.that would be the appropriate domain.... so that is another thing
to check for.

But only Xavier can tell which is best.
Click to expand...

It may be that he needs both, but there may not be any way to determine
which he needs in any specific circumstance. It may be that everything that
ends in .com can be extracted using your method and everything else using my
method.

As you say, only Xavier can determine exactly what he needs.
 
IanC said:
Good point.

It may be that he needs both, but there may not be any way to determine
which he needs in any specific circumstance. It may be that everything
that ends in .com can be extracted using your method and everything else
using my method.

As you say, only Xavier can determine exactly what he needs.
Click to expand...

Hi,
Very kind of you guys to help me out.
But I have been trying these formula's out in Excel 2007 and none of them
seems to work here??
I have no idea why.

The domain name of the mail addresses mostly consist of 1 word.
This might help you guys out.

Thanks for helping me out!

Xavier Vanmeerhaeghe
 
Xavier,

What value do you have?
What cell is it in?
What is your exact formula?
What result are you seeing?
What is the format of the cell with the formula? (if it is text, the formula won't work, even though
you want to return a 'text' value, you should use General)

HTH,
Bernie
MS Excel MVP
 
Hi,

If i have a column with mail addresses.
Is it possible then to withdraw the domain name from the address to the
column next to it?
example: cell A1= (e-mail address removed), cell A2=
(e-mail address removed), and so on.
cell B1= domainname33, cell B2= domainname99
thanks in advance!

With kindest regards,
Xavier Vanmeerhaeghe
Click to expand...

To return the word between the "@" and the first ".", you can use this:

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

--ron
 
Hi guys,
I solved the problem. I am using a dutch version of office.
So i had to chance the formula's to the dutch variant.
Everything is working now.

Thans a lot!

greets,
xavier vanmeerhaeghe
 
Back
Top