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
Bookmarks