sorting lists

[TimJames]

I have a list with entries like so:

1990CJ000123
1991CJ000124
1992DJ000124
1993CJ000125
1992CJ000124
1992CJ000125
1992CJ000126
1991DJ000137

How can I sort the lists by the year (IE 1991, etc) but make sure the DJ's
and the CJ's are mixed together? In other words, I do not want the entries
that contain CJ to be at the top of the list and the DJ entries to be at the
bottom.

 

[David Biddulph]

Produce a helper column =LEFT(A2,4)&RIGHT(A2,6)
and sort by that.

 

[Bob Phillips]

Add a helper column with a formula of

=--Left(A1,4)

and sort on that column.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jim Cone]

A standard Excel ascending sort produces...
1990CJ000123
1991CJ000124
1991DJ000137
1992CJ000124
1992CJ000125
1992CJ000126
1992DJ000124
1993CJ000125
It doesn't appear that any special sorting methods are necessary.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming - check out Special Sort)




"TimJames"
wrote in message
I have a list with entries like so:

1990CJ000123
1991CJ000124
1992DJ000124
1993CJ000125
1992CJ000124
1992CJ000125
1992CJ000126
1991DJ000137

How can I sort the lists by the year (IE 1991, etc) but make sure the DJ's
and the CJ's are mixed together? In other words, I do not want the entries
that contain CJ to be at the top of the list and the DJ entries to be at the
bottom.