Possible to sort part of a cell?
 

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

Possible to sort part of a cell?
 

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

Possible to sort part of a cell?
 

try putting this in a helper column
=MID(E6,FIND(".",E6)+1,FIND("@",E6)-FIND(".",E6)-1)
--
Don Guillett
SalesAid Software

"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

Possible to sort part of a cell?
 

Thanks, it works.


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

Possible to sort part of a cell?
 

glad to help but Tom was faster.

--
Don Guillett
SalesAid Software

"helios02" wrote in
message ...

Thanks, it works.


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