Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

alpha-numeric sorting

Status
Not open for further replies.
phil5

phil5

Technical User
Oct 24, 2008
1
US
I have an inventory file that I want to sort by bin locations (ie 1A1 to 1Z99) the problem is I get 1A1,1A10 through 1A19 before I get 1A2 then 1A21 through 1A29, 1A3.
How can I work this out?
 
Sort by date Sort by votes
One suggestion is to name the 1A1 to 1A9 locations 1A01 to 1A09. That way everything up to 1A99 will sort correctly.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

concomp
  • Locked
  • Question
Cell Numeric Format.
Replies
1
Views
29
Blujacket
Blujacket
syl93
  • Locked
  • Question
Sorting problem in Lotus 123 2
Replies
11
Views
165
DaleWatson123321
DaleWatson123321
Icewizz
  • Locked
  • Question
Lotus 123 Sorting macro???? 1
Replies
3
Views
60
Icewizz
Icewizz

Part and Inventory Search

Sponsor

Back
Top