| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 -- darkjedi ------------------------------------------------------------------------ darkjedi's Profile: http://www.excelforum.com/member.php...o&userid=29153 View this thread: http://www.excelforum.com/showthread...hreadid=536350 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom sorting with Letters and Zeros
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 -- darkjedi ------------------------------------------------------------------------ darkjedi's Profile: http://www.excelforum.com/member.php...o&userid=29153 View this thread: http://www.excelforum.com/showthread...hreadid=536350 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Letters and 000s in front of actual number not sorting correctly | Excel Discussion (Misc queries) | |||
| Need help with TRIM function | Excel Worksheet Functions | |||
| Leading Zeros with a twist. | Excel Discussion (Misc queries) | |||
Linear Mode
