extracting email domain

[Stephanie]

Is there a formula I can use for extracting email domain
info.

Ex:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

Just pulling

aol
hotmail
comcast

into another cell?

Stephanie

 

[J.E. McGimpsey]

One way:


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


where 255 is just a large number to ensure the whole domain is
returned.

 

[Ashish Mathur]

Hi,

Suppose you have the names in column A. Enter the
following formula in column B to extract the domail names

MID(A1,MATCH("@",MID(A1,ROW($1:$96),1),0)+1,(MATCH(".",MID
(A1,ROW($1:$96),1),0)+1)-(MATCH("@",MID(A1,ROW
($1:$96),1),0)+1)-1)

Press Ctrl+Shift+Enter after typing/copying the formula

Regards,

Ashish Mathur
Excel - MVP

 

[Peo Sjoblom]

One way that will work for most emails

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

replace A1 with the first cell with email address and
copy down

regards,

Peo Sjoblom

 

[Jill]

Stephanie,

Replace all the A1's in this formular with the cell that
contains the full email address.

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

Jill