| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort column of e-mail addresses
I am trying to sort by the address Any ideas? I am
completely lost. Matt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort column of e-mail addresses
Create another column which has =mid(A1,find("@",A1)+1,255) (Where A1 is the
first address), then fill down as far as you need, calculate, if necessary, then sort both columns on this formula column, then clear this formula column. Bob Umlas Excel MVP "Matty" wrote: I am trying to sort by the address Any ideas? I am completely lost. Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| sort a column of e-mail addresses by domain | Excel Discussion (Misc queries) | |||
| How do I format a column in alpha order? | New Users to Excel | |||
| How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
