extracting email domain

J

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.
 
A

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
 
P

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
 
J

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
 
Top