Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alphabetizing E-mail Addresses
How about a helper column that finds the @ and places all to the right in
the cell. Sort by that col -- Don Guillett Microsoft MVP Excel SalesAid Software "timfear" wrote in message ... I've looked around for this and couldn't find an answer. I'm trying to alphabetize a list of e-mail address but want to do it by domain, so after the @ sign. How can I do this? Example: Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alphabetizing E-mail Addresses
You could rip the addresses apart with Data\Text to Columns..., sort by
domain and then re-assemble, but I suspect that's not exactly what you are looking for, is it? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alphabetizing E-mail Addresses
Insert a new column next to your email addresses and enter the formula
=MID(A1,FIND("@",A1)+1,LEN(A1)) in the first cell in that column and copy down as far as you need to go. Then, sort the rows using that column as the sort key. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "timfear" wrote in message ... I've looked around for this and couldn't find an answer. I'm trying to alphabetize a list of e-mail address but want to do it by domain, so after the @ sign. How can I do this? Example: Thanks, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alphabetizing E-mail Addresses
I would add a new column into your spreadsheet with the following formula:
=MID(A1,FIND("@",A1)+1,10) Where cell A1 is the first email address. Then copy this formula down. This will then show the text after the @ and allow you to the sort this column in the normal way. "timfear" wrote: I've looked around for this and couldn't find an answer. I'm trying to alphabetize a list of e-mail address but want to do it by domain, so after the @ sign. How can I do this? Example: Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I sort e-mail addresses? | Excel Discussion (Misc queries) | |||
Outlook used to remember E-mail addresses | Excel Discussion (Misc queries) | |||
E-Mail Addresses in Excel | Excel Discussion (Misc queries) | |||
E-mail Addresses in Excel | Excel Discussion (Misc queries) | |||
E-mail addresses in Excel 2000 | Excel Discussion (Misc queries) |