Formula to extract doamin names form email address,s

[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

 

[Dave Peterson]

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

 

[barry houdini]

Another formula option

=REPLACE(A1,1,FIND("@",A1),""

 

[Ron Rosenfeld]

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

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

--ron

 

[Ox]

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

--ron

Thank You all for your assistance problem has been solved

 

[Ox]

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

Thank You all for your assistance problem has been solved

 

[Ox]

Another formula option

=REPLACE(A1,1,FIND("@",A1),"")

Thank You all for your assistance problem has been solved