| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| Using Macro to Sort Names, Numbers & addresses | Excel Worksheet Functions | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) | |||
Linear Mode
