G Guest Jul 6, 2005 #1 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'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 Jul 6, 2005 #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.
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.
G Guest Jul 6, 2005 #3 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...
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 Jun 24, 2008 #4 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?
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 Jun 24, 2008 #5 Depending on what's in the cells, this may work: =a1&"@"&b1 or =hyperlink("mailto:"&a1&"@"&b1,"Click me") to make a clickable link.
Depending on what's in the cells, this may work: =a1&"@"&b1 or =hyperlink("mailto:"&a1&"@"&b1,"Click me") to make a clickable link.
