Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting Numbers
Hi everyone. I use excel to sort part numbers for the company I work for and
I have been doing it manually through cut and paste. I am hoping someone on here can help me find an easier way. The problem I have is the part numbers are 2, 3, 4, 5 digits long and we like to keep all the 2 digit numbers together, 3 digit numbers together etc. When I use the sort feature it mixes them all up is there any way to sort them so they come out the way I want them. I hope I made this clear enough, thanks for any help. |
#2
|
|||
|
|||
Add an extra column to the left of your part numbers - and assuming your part
numbers are then in column B, use this formula to create a new list on which to sort =TEXT(B2,"00000") Now your 2 digit part numbers will look like "000012" and if you sort on this column, all the numbers will stay together the way you want "bcboy4ca" wrote: Hi everyone. I use excel to sort part numbers for the company I work for and I have been doing it manually through cut and paste. I am hoping someone on here can help me find an easier way. The problem I have is the part numbers are 2, 3, 4, 5 digits long and we like to keep all the 2 digit numbers together, 3 digit numbers together etc. When I use the sort feature it mixes them all up is there any way to sort them so they come out the way I want them. I hope I made this clear enough, thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
sorting numbers more than one decimal | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Sorting numbers | New Users to Excel |