Email Sorting

J

JE McGimpsey

One way:

Copy addresses to an unused column. Choose Data/Text to Columns. Select
Delimited, Click Next, check Other and enter @, click Next. Select the
first column and choose the "Do not import column radio button". Click
Finish.

Sort on the column of domains.
 
B

Bill Ridgeway

Apologies for answering a question with a question.

Would it be possible abstract all character after the '@' and use that as a
sort string? It isn't an unreasonable expectation but I can't seem to find
the key for the formula.

Regards.

Bill Ridgeway
Computer Solutions
 
J

JE McGimpsey

One way:

=MID(A1,FIND("@",A1)+1,256)

where 256 is just a large number to ensure that all characters are
captured.
 
B

Bill Ridgeway

Thanks JE McGimpsey (sorry to be so formal)

So, if the OP has a database, a helper column with the formula -
=MID(A1,FIND("@",A1)+1,256)&LEFT(A1,5)
would concatenate the last element with the first and last element to
provide a sort string. Accepted that the last element is included twice but
this overhead is less than trying to exclude it.

Regards.

Bill Ridgeway
Computer Solutions
 
J

JE McGimpsey

No need to add the &LEFT(A1,5) if you sort on 2 columns: the domain
column first, then the original address column.
 
Top