+ Reply to Thread
Results 1 to 4 of 4

Custom sorting with Letters and Zeros

  1. #1
    Registered User
    Join Date
    11-28-2005
    Posts
    15

    Custom sorting with Letters and Zeros

    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

  2. #2
    Barb Reinhardt
    Guest

    RE: 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
    >
    >


  3. #3
    Jim Cone
    Guest

    Re: Custom sorting with Letters and Zeros

    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


  4. #4
    Registered User
    Join Date
    11-28-2005
    Posts
    15
    The Item number are dependent of the manufacture. We have over 300 manufactures, so it could start with AC1 and end with ZT121. It can also start with 2 to 3 letters. The letters and numbers of the item number are together.

    Thanks
    Darkjedi

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1