Formula to extract doamin names form email address,s

  • Thread starter Thread starter Ox
  • Start date Start date
O

Ox

I have a large list of email address and would like to group them by
the doamin that they came from

I would like to add another collum and and list the doamin names in
this

collum A collum B
ie (e-mail address removed) abc.com

does any one have a formula to do this
 
You could use a formula, but I wouldn't.

I'd copy that column of data into another column.

Then select the new column
Edit|Replace
what: *@
with: (leave blank)
replace all

===
But you could use a formula like:
=mid(a1,search("@",a1)+1,255)
(255 is just a big enough number to grab everything to the right of the @ sign).
 
I have a large list of email address and would like to group them by
the doamin that they came from

I would like to add another collum and and list the doamin names in
this

collum A collum B
ie (e-mail address removed) abc.com

does any one have a formula to do this
Click to expand...


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

--ron
 
You could use a formula, but I wouldn't.

I'd copy that column of data into another column.

Then select the new column
Edit|Replace
what:  *@
with:  (leave blank)
replace all

===
But you could use a formula like:
=mid(a1,search("@",a1)+1,255)
(255 is just a big enough number to grab everything to the right of the @sign).
Click to expand...


Thank You all for your assistance problem has been solved
 
Back
Top