G
Guest
Dear Sir,
I find that Excel 2002 could sort alphanumeric references of the same length
very well but not the references with different number of character as
illustrated below.
Same Length Different Length
(No problem in sorting) (Unable to sort in this sequence)
FG0001 FG1
FG0012 FG12
FG0241 FG241
FG6806 FG6806
For references with different number of character, Excel could only group
the same item together but not in ascending or descending order.
Is there anyway for it to sort in sequence?
Thanks
Low
I find that Excel 2002 could sort alphanumeric references of the same length
very well but not the references with different number of character as
illustrated below.
Same Length Different Length
(No problem in sorting) (Unable to sort in this sequence)
FG0001 FG1
FG0012 FG12
FG0241 FG241
FG6806 FG6806
For references with different number of character, Excel could only group
the same item together but not in ascending or descending order.
Is there anyway for it to sort in sequence?
Thanks
Low