If you make a dummy column and extract the last name

assume the example is in A1. Then in B1 enter

=MID(A1,FIND(".",A1)+1,FIND("@",A1)-FIND(".",A1)-1)

And drag fill down the column. Now sort columns A and B with B as the key
column.

--
Regards,
Tom Ogilvy


"helios02" wrote in
message ...

I have a column with email addresses in the format:
. Is it possible to sort these in
order based on the last name?


--
helios02
------------------------------------------------------------------------
helios02's Profile:
http://www.excelforum.com/member.php...o&userid=29791
View this thread: http://www.excelforum.com/showthread...hreadid=494969