ExcelBanter - Sort column of e-mail addresses

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sort column of e-mail addresses (https://www.excelbanter.com/excel-discussion-misc-queries/119422-sort-column-e-mail-addresses.html)

Matty

Sort column of e-mail addresses

I am trying to sort by the address Any ideas? I am
completely lost.

Matt

Bob Umlas, Excel MVP

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

All times are GMT +1. The time now is 10:10 PM.