Dear Sir,

Thanks for your helpful information.


Best Regards

Low

--
A36B58K641


"Pete_UK" wrote:

You could turn your Different Length strings into Same Length strings
by means of a formula like this in a helper column:

=LEFT(A1,2)&TEXT(RIGHT(A1,LEN(A1)-2),"0000")

and copy down as needed. Alternatively, you could just extract the
number part into a helper column with this:

=VALUE(RIGHT(A1,LEN(A1)-2))

and copy this down.

Either way, you then use the helper column as the sort key.

Hope this helps.

Pete


On Jul 16, 2:34 pm, Mr. Low wrote:
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

--
A36B58K641