Email Sorting

[coolantsv]

I have a column with email addresses. I'd like them grouped and sorted
by email address.

(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

would become..

(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

Thanks!

 

[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.

 

[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

 

[JE McGimpsey]

One way:

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

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

 

[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

 

[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.