Excel Sorting Help

craigmbrooks

Active member
1,127
5.00 star(s)
Have a sorting question, how do get excel to sort in the proper order? Example below, notice 15 is after 144! Any help with this would be greatly appreciated, know if you put 00's in front it works but don't want to go through 7000+ cards putting 00's in front of them. Help please, sure there's a way, just don't know how.

1996 Collector's Choice 1 Cal Ripken
1996 Collector's Choice 100 Don Mattingly TT
1996 Collector's Choice 101 Roger Clemens TT
1996 Collector's Choice 102 Raul Mondesi TT
1996 Collector's Choice 103 Cecil Fielder TT
1996 Collector's Choice 105 Frank Thomas TT
1996 Collector's Choice 110 Ron Gant
1996 Collector's Choice 112 Hal Morris
1996 Collector's Choice 119 Carlos Baerga
1996 Collector's Choice 120 Jim Thome
1996 Collector's Choice 121 Jose Mesa
1996 Collector's Choice 123 Dave Winfield
1996 Collector's Choice 124 Eddie Murray
1996 Collector's Choice 144 Lou Whitaker
1996 Collector's Choice 15 John Wasdin
1996 Collector's Choice 150 Andre Dawson
1996 Collector's Choice 155 Charles Johnson
 

cardcollector01

New member
1,568
4.90 star(s)
Hey,

Becka and myself found a way to organize the cards in our excel file, but its a ltitle more time consuming.

Row A - Put the year and brand
Row B - Put the card number
Row C - Put the name of the player(s)

Then, highlight the card numbers from first to last, then click sort A-Z. The cards will now be in order from smallest to largest.

Hope that helped a little :)

Robbie & Becka
 

opcfan

New member
227
5.00 star(s)
Try numbering the cards under 100 with a 0 eg 001 015. this is what I do. Jim
Have a sorting question, how do get excel to sort in the proper order? Example below, notice 15 is after 144! Any help with this would be greatly appreciated, know if you put 00's in front it works but don't want to go through 7000+ cards putting 00's in front of them. Help please, sure there's a way, just don't know how.

1996 Collector's Choice 1 Cal Ripken
1996 Collector's Choice 100 Don Mattingly TT
1996 Collector's Choice 101 Roger Clemens TT
1996 Collector's Choice 102 Raul Mondesi TT
1996 Collector's Choice 103 Cecil Fielder TT
1996 Collector's Choice 105 Frank Thomas TT
1996 Collector's Choice 110 Ron Gant
1996 Collector's Choice 112 Hal Morris
1996 Collector's Choice 119 Carlos Baerga
1996 Collector's Choice 120 Jim Thome
1996 Collector's Choice 121 Jose Mesa
1996 Collector's Choice 123 Dave Winfield
1996 Collector's Choice 124 Eddie Murray
1996 Collector's Choice 144 Lou Whitaker
1996 Collector's Choice 15 John Wasdin
1996 Collector's Choice 150 Andre Dawson
1996 Collector's Choice 155 Charles Johnson
 

craigmbrooks

Active member
1,127
5.00 star(s)
Hey,

Becka and myself found a way to organize the cards in our excel file, but its a ltitle more time consuming.

Row A - Put the year and brand
Row B - Put the card number
Row C - Put the name of the player(s)

Then, highlight the card numbers from first to last, then click sort A-Z. The cards will now be in order from smallest to largest.

Hope that helped a little :)

Robbie & Becka



Try numbering the cards under 100 with a 0 eg 001 015. this is what I do. Jim

Thanks guys but not really wanting to retype over 7000+ cards, I do eventually want to add a separate column as you do, cardcollector01, for what team they are pictured as so I can sort by that also. Word does not sort this way only excel, may try a paste into Word and sort and paste back to excel. Was wondering if you can change the format of cells some way to make it sort right in excel. Thanks, Craig

Edit: The copying to Word thing does NOT work either.
Second Edit: The Word thing works if you sort by number and not text.
 
Last edited:

DenMan24

New member
25
5.00 star(s)
Have you tried: right clicking on the column header with the numbers, select format cells and in the number tab, select number and set the decimal to 0. Now try sorting on that column.
 

Big Daddy

Active member
319
5.00 star(s)
There is a feature called "Text to columns". This will take your one line entry and you can break it into how ever many columns you need. You can then sort by the card number column.
 

rynofan23

Active member
171
5.00 star(s)
There is a feature called "Text to columns". This will take your one line entry and you can break it into how ever many columns you need. You can then sort by the card number column.

Problem is, this would only work if he had a fixed width. Set names could vary too much in length to get a clean text to column. A delimiter won't work either
 

Big Daddy

Active member
319
5.00 star(s)
Problem is, this would only work if he had a fixed width. Set names could vary too much in length to get a clean text to column. A delimiter won't work either

You can use the "space" as a delimiter. The only downside to that are Jr's, III's, and others with 3 names.
 

craigmbrooks

Active member
1,127
5.00 star(s)
Thanks for the advice guys!

Appreciate the ideas will try them out.

rynofan23, if I can't get it to work, will send you a PM asking you to check your email inbox.
DenMan24, each script "1996 Collector's Choice 1 Cal Ripken" is in one cell, otherwise that would work. Will try BigDaddy's suggestion of breaking them apart, then it'll work that way.

Thanks, Craig





Craig,
If you email me your spreadsheet, I can write a quick script that splits them up for you.

Tai
taile_23@cox.net

Have you tried: right clicking on the column header with the numbers, select format cells and in the number tab, select number and set the decimal to 0. Now try sorting on that column.

There is a feature called "Text to columns". This will take your one line entry and you can break it into how ever many columns you need. You can then sort by the card number column.
 
Top