How can I sort e-mail addresses?

  • Thread starter Carter Devereaux
  • Start date
C

Carter Devereaux

I'm trying to sort a long list of email addresses by the name that follows
the "@". What's the best way to do something like that?
 
D

Dave Peterson

I'd select the column and use data|text to columns to extract everything after
the @ symbol. Then sort the data by that column.

Another way...

Copy that column to another column.
Select that new column
Edit|replace
what: *@
with: (leave blank)
replace all

Then sort your data by that column.
 
C

Carter Devereaux

Genius! Worked perfectly!

Dave Peterson said:
I'd select the column and use data|text to columns to extract everything after
the @ symbol. Then sort the data by that column.

Another way...

Copy that column to another column.
Select that new column
Edit|replace
what: *@
with: (leave blank)
replace all

Then sort your data by that column.
Click to expand...
 
D

dillon1247

Hi I did this too and it workd great. Just wondering though how do you
recombine the now sorted colums so the e-mail addresses are complete?
 
D

Dave Peterson

Depending on what's in the cells, this may work:

=a1&"@"&b1

or
=hyperlink("mailto:"&a1&"@"&b1,"Click me")
to make a clickable link.
 
Top