How can I sort e-mail addresses?
 

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?

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.

Carter Devereaux wrote:

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?

--

Dave Peterson

Genius! Worked perfectly!

"Dave Peterson" wrote:

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.

Carter Devereaux wrote:

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?

--

Dave Peterson

How can I sort e-mail addresses?
 

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?



"Carter Devereaux" wrote:

Genius! Worked perfectly!

"Dave Peterson" wrote:

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.

Carter Devereaux wrote:

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?

--

Dave Peterson

How can I sort e-mail addresses?
 

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

=a1&"@"&b1

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




dillon1247 wrote:

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?

"Carter Devereaux" wrote:

Genius! Worked perfectly!

"Dave Peterson" wrote:

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.

Carter Devereaux wrote:

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?

--

Dave Peterson


--

Dave Peterson