Sorting

[appeng]

I am trying to sort alpha-numeric cells all in the same column. But I cannot
get the sort in order.

For example;
COND7
COND8
COND9
COND10
COND11
COND12
COND13
COND14
COND15
COND16
COND17
COND18
COND109
COND110
COND111
COND112
1SHDAE
151E2
30SHDY
31SHDY

Sort Result is not what I would expect
151E2
1SHDAE
30SHDY
31SHDY
COND10
COND109
COND11
COND110
COND111
COND112
COND12
COND13
COND14
COND15
COND16
COND17
COND18
COND7
COND8
COND9

 

[JE McGimpsey]

Don't know what you expected - did you look at the "When I sort, I do
not get the results I expect" topic in XL Help?

 

[appeng]

I was expeciting at least to see

COND7
COND8
COND9
COND10
COND11
COND12
COND13
COND14
COND15
COND16
COND17
COND18
COND109
COND110
COND111
COND112

 

[Dave Peterson]

Excel is sorting the data in an alpha-numeric order (just like a dictionary
would). And 1's come before 2's.

You could either extract the numbers from your data into a different column.
And sort your range by these two helper columns (Cond in one column, 7 in the
next).

Or you could edit your entries:

Cond0007
cond0008
cond0009
cond0010
....

To get the sort you want.

 

[Jim Cone]

There is a commercial alternative available: "Special Sort" from yours truly...
http://www.realezsites.com/bus/primitivesoftware
(you can try it before buying)
--
Jim Cone
San Francisco, USA


"appeng" <[email protected]>
wrote in message
I was expeciting at least to see

COND7
COND8
COND9
COND10
COND11
COND12
COND13
COND14
COND15
COND16
COND17
COND18
COND109
COND110
COND111
COND112