extracting email domain

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

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
 
One way:


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


where 255 is just a large number to ensure the whole domain is
returned.
 
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
 
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
 
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
 
Back
Top