Custom sorting with Letters and Zeros

[darkjedi]

Hi were have problems in sorting out our inventory item numbers. We have
over 15,000 item numbers that can't be changed or zeros deleted. The
problem is when there are zeros in the item number.

Excell sort
CA0002
CA00020
CA0021
CA02
CA021
CA02C

Needs to be
CA0002
CA02
CA02C
CA00020
CA0021
CA021

Thanks

 

[Barb Reinhardt]

Several questions:

1) Do the inventory numbers ALWAYS start with 2 characters?
2) Are the numbers all together within the inventory number?

Answer this and maybe we can give you a more detailed response. I believe
you'll need to have a couple of helper columns for this however. The first
would be for the two character code at the beginning:

=left(A1,2)

I believe there is a function that extracts values, but someone else may
need to help with that.

 

[Jim Cone]

The "Special Sort" commercial add-in from yours truly will do that...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA


"darkjedi"
wrote in message
Hi were have problems in sorting out our inventory item numbers.
We have over 15,000 item numbers that can't be changed or zeros deleted.
The problem is when there are zeros in the item number.

Excell sort
CA0002
CA00020
CA0021
CA02
CA021
CA02C

Needs to be
CA0002
CA02
CA02C
CA00020
CA0021
CA021

Thanks

 

[darkjedi]

The Item number are dependent of the manufacture. We have over 30
manufactures, so it could start with AC1 and end with ZT121. It ca
also start with 2 to 3 letters. The letters and numbers of the ite
number are together.

Thanks
Darkjed