View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt
 
Posts: n/a
Default Custom sorting with Letters and Zeros

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.


"darkjedi" wrote:


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
------------------------------------------------------------------------
darkjedi's Profile: http://www.excelforum.com/member.php...o&userid=29153
View this thread: http://www.excelforum.com/showthread...hreadid=536350