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
|